Hi Woodle2,

Assume that the company names are in column A, the adresses are in column B
and each address line has a unique separator such as a comma (,).

With the adress cells selected:

Data | Text to Columns | Delimited | Next | select the Comma option | Finish

If you need to automate this process, turn on the macro recorder while you
perform the required steps manually. This will provide you with code which
may be edited to enable more general application

If you experience problems with such editing, post back with details,


---
Regards,
Norman



"wood1e2" wrote in
message ...

hi

I am looking to move data from one cell to another...I have been moving
some of the date with cut and paste...takes so long...

Basically want to move a list of company names and address so that each
line of the address is in individual cellls...At the moment I have the
company names in one cell each...but the next cell have the full
address in. I would like to spllit up the address into individual
cells...so the address read left to right...

cheers


--
wood1e2
------------------------------------------------------------------------
wood1e2's Profile:
http://www.excelforum.com/member.php...o&userid=32971
View this thread: http://www.excelforum.com/showthread...hreadid=527990