Separate address column

  • Thread starter Thread starter Gerry Kuta
  • Start date Start date
G

Gerry Kuta

I would appreciate help in splitting numbers from text in
an address field.

In A1 I have 3 or 4 numbers, a space, text, space, text...
but the text portion can be variable.
I would like to extract to Column B the number and to
column C the text.
Examples:
123 Anywhere St.
1234 Anywhere St
123 Anywhere
1234 Anywhere St.

Is there a formula solution to this problem?

TIA
Gerry
 
B1:

=LEFT(A1,FIND(CHAR(32),A1)-1)

C1:

=MID(A1,FIND(CHAR(32),A1)+1,255)

HTH
Jason
Atlanta, GA
 
Back
Top