Hi and thanx in advance.
I am new to this and this is probably a stupid question....

I have a list of addresses...... in on column
A
21 Brook St
21 Buck St
21 Bucker St

I want to cut the 21's and paste them to a new columm/cell so it looks like this

A B
21 Brook St
21 Buck St
21 Bucker St

when I make a macro it changes the numbers but all the street change to Brook St....

A B
21 Brook St
21 Brook St
21 Brook St

Does anyone have a link to a video I can watch or know what I am doing wrong.....
Thanks....