Cell problems - need a quicker way.
 

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

Cell problems - need a quicker way.
 

Hi

If the parts of the address are separated by commas, you can use Data/Text
to columns. Select the column, tell the wizard that the delimiter is a
comma - and away you go.
Make sure you back up the data before you start.

Andy.

"lara5555" wrote in
message ...

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

Cell problems - need a quicker way.
 

Hi Andy,

Thanks for that, works like a charm....you've save me about a weeks
worth of work.

Cheers.

Lara


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