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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i add commas in a single cell? 2
Identifying text to split into columns 7
Transposeing data 2
Extract Mailing Address to multiple cells 1
With F1 value, look at A, if match or partial match return B 5
Splitting Text from single cell in column across multiple Columns 3
MID, LEFT, RIGHT help 5
Hep with Find and Replace 16

Back
Top