Macro to cut one figure from a cell

[ShaneinFNQ]

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....

[xladept]

Hi Shanein,

Welcome to the forum - can you post the code you've developed? (Be sure to highlight it and click on the #).

[ShaneinFNQ]

I haven't written a code..... just recorded it.... sorry I am a newbie.... cant seem to view the code in vbasic..

[FDibbins]

Hi and welcome to the forum

There are a few ways to do this without using VBA.

1 would be to use Text2Columns - Fixed Width, and remove all devisions you dont wat.
an alternative would be to use a helper column with a formula to extract the value...
=left(A1,find(" ",A1,1)-1)

[xladept]

Hi Shanein,

With Excel prominent, Alt + F8 will show you the macros that you have and then you need only highlight the macro name and choose Edit in order to see it

And - thanks for the rep!

Here's some simple code:

Please Login or Register  to view this content.