Splitting a cell???

[Brw]

I have a long list of data combined in once column by
cell. The data in each cell includes a phone number and
address. I would like to split that data into two
different cells. Is this possible and if so how?

The data looks like this:

(555) 555-5555 999 Broadway, Apt A
etc.
etc..
etc...

Any advise?
Brw

 

[RagDyer]

Try <Data> <TextToColumns>
Check "FixedWidth", <Next>
Read the directions to move the break line to the end of the phone numbers
and eliminate any others,
Then <Finish>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a long list of data combined in once column by
cell. The data in each cell includes a phone number and
address. I would like to split that data into two
different cells. Is this possible and if so how?

The data looks like this:

(555) 555-5555 999 Broadway, Apt A
etc.
etc..
etc...

Any advise?
Brw

 

[CLR]

Select the column, then Data > Text to Columns > Fixed Width > Next > then
move all the seperator lines you don't want, off to the left
side...........then Next > Finish.......

Vaya con Dios,
Chuck, CABGx3

 

[Norman Harker]

Hi Brw!

Can we have more examples?

For example, is there always two spaces between the telephone number
and the address.

--
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.