Excel Columns 2

[cheech25]

Hi,

I have an excel spreadsheet. In thes spreadsheet I have columns with street number and street name in one cell. I need create a new column that will remove the number without going into each cell and deleting the number. Please help with maybe some type of "if statement" or anything that will help.

Thank you so much for your help.

Thank You

 

[Lilliabeth]

=LEFT(A1,FIND(" ",A1))
will return everything to the left of the first space character.

Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[AnotherHiggins]

You can just take everything to the left of the first space to return the street number, then everything to the right of the first space to return the street name.

Street Number:
[COLOR=blue white]=LEFT(A1,FIND(" ",A1)-1)[/color]

Street Name:
[COLOR=blue white]=RIGHT(A1,LEN(A1)-FIND(" ",A1))[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[cheech25]

Thank you so much Lilliabeth and anotherhiggins. You saved me.

Thank You