software

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 quot;123 Any
Road, Any Village, Any Townquot; 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: www.excelforum.com/member.php...foamp;userid=2741
View this thread: www.excelforum.com/showthread...hreadid=501037Hi

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.

quot;lara5555quot; gt; wrote in
message ...
gt;
gt; Hi there,
gt;
gt; I'm new to this forum and was wondering if anyone can help me.
gt;
gt; I have a spreadsheet that has an address column with data already
gt; filled in. for examle a cell in this column could contain quot;123 Any
gt; Road, Any Village, Any Townquot; and I need this cell to be spilt into 3
gt; invidiual columns so that eventually the spreadsheet can be exported
gt; into another programme (ConQuest). i.e:
gt; Cell in Column A = 123 Any Road
gt; Cell in Column B = Any Village
gt; Cell in Column C = Any Town
gt;
gt; Does any one a quicker way to do this other then cutting and pasting
gt; words from one cell into another.
gt;
gt; Thanks
gt;
gt; Lara
gt;
gt;
gt; --
gt; lara5555
gt; ------------------------------------------------------------------------
gt; lara5555's Profile:
gt; www.excelforum.com/member.php...foamp;userid=2741
gt; View this thread: www.excelforum.com/showthread...hreadid=501037
gt;

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: www.excelforum.com/member.php...foamp;userid=2741
View this thread: www.excelforum.com/showthread...hreadid=501037