Hi there,

I'm new to this forum and was wondering if anyone can help me.

I have a spreadsheet that has an address column with data already
filled in. for examle a cell in this column could contain "123 Any
Road, Any Village, Any Town" and I need this cell to be spilt into 3
invidiual columns so that eventually the spreadsheet can be exported
into another programme (ConQuest). i.e:
Cell in Column A = 123 Any Road
Cell in Column B = Any Village
Cell in Column C = Any Town

Does any one a quicker way to do this other then cutting and pasting
words from one cell into another.

Thanks

Lara


--
lara5555
------------------------------------------------------------------------
lara5555's Profile: http://www.excelforum.com/member.php...fo&userid=2741
View this thread: http://www.excelforum.com/showthread...hreadid=501037