separate string on basis of where "space" exists

[jcg31]

I need to separate the number in an address from the street name.
345 First Holland Avenue

So I would get 345 to place in one cell and then the balance to place in another.

Any help would be appreciated.
Jim

 

[JonathanVallee]

Hey, here's a quick way you can do that. Use the left and find formula.

Assuming the address is in cell A1

=LEFT(A1,FIND(" ",A1,1))

Hope this helps, thanks.

 

[T. Valko]

I need to separate the number in an address from the street name.
345 First Holland Avenue

So I would get 345 to place in one cell and then the balance to place in another.

Any help would be appreciated.
Jim

Try these...

A2 = 345 First Holland Avenue

Formula entered in B2:

=LEFT(A2,FIND(" ",A2)-1)

Formula entered in C2:

=MID(A2,FIND(" ",A2)+1,100)

 

[jcg31]

Perfect!
Thanks folk>
Jim

 

[T. Valko]

Perfect!
Thanks folk>
Jim

You're welcome. Thanks for the feedback!