Separate phone number and address

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

how do I separate this?

73458202021035 MOLLNO ST

I need to have the first 10 digits (phone number)
separated from the address into a different cell.
should be
column1 column2
7345820202 1035 Mollno st

If I could copy the first 10 characters to paste in
another column and delete the first 10 characters in the
original column, this would work, but I dont know how to
do it.

Thanks in advance,

Tom
 
Hi
have a look at 'Data - Text to columns' Choose a fixed length (10
characters) in your case
 
Hi Tom!

You could use Data > Text to columns and use a fixed width to separate out
the telephone number.

Or you could use helper column formulas:

Telephone numbers:
=LEFT(A1,10)
Address:
=RIGHT(A1,LEN(A1)-10)

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top