Change cell contents inot two cells

  • Thread starter Thread starter M
  • Start date Start date
M

M

I am trying to take an address in a cell:
ex: 555 Main St.
And make it into two seperate cells:
ex1: 555
ex2: Main St.

I know there is a simple way of doing this, can anyone
help?

Thanks,
M
 
Highllight the column, then, Data > Text to columns > Fixed width > Next,
then left-click on the dividing arrow between "main" and "St.", and drag it
off to the left side of the window, then > Finish.............

Vaya con Dios,
Chuck, CABGx3
 
M, if your address is in A1, and it looks like the one in your example,
then:

1-In B1 put this formula: =LEFT(A1,FIND(" ",A1)-1)
2-In C1 put this formula: =RIGHT(A1,LEN(A1)-LEN(LEFT(A1,FIND(" ",A1))))
3-Copy both formulas down.
4-Select all cells containing the formulas, right-click and Edit > Copy;
right-click and Edit > Paste Special > Values > OK.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
Back
Top