software

I have a large amount of text in one cell separated by a semi colon. I would
like to separate the data into several cells by semi colon.

Any help would be great.

Thanks

lt;Datagt; lt;Text to Columns...gt;
Then, select quot;Delimitedquot;, hit next, and check Semi Colon--
Regards,
Davequot;bsantonaquot; wrote:

gt; I have a large amount of text in one cell separated by a semi colon. I would
gt; like to separate the data into several cells by semi colon.
gt;
gt; Any help would be great.
gt;
gt; Thanks

Data/Text to columns. Click Delimited, Next, check the Semicolon
checkbox, and click Finish.

In article gt;,
quot;bsantonaquot; gt; wrote:

gt; I have a large amount of text in one cell separated by a semi colon. I would
gt; like to separate the data into several cells by semi colon.
gt;
gt; Any help would be great.
gt;
gt; Thanks


Use Text to Columns. Select the cell you want to separate. Go to
Data/Text to Columns. Step 1 Delimited should be selected. Click Next.
Step 2. In the Delimeters select the check box next to semi-colon.
This will give you a preview of where the break will be. Click next.
Step 3, select the format. Click Finish.
HTH

Cheers,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=495530On Thu, 22 Dec 2005 07:49:02 -0800, quot;bsantonaquot;
gt; wrote:

gt;I have a large amount of text in one cell separated by a semi colon. I would
gt;like to separate the data into several cells by semi colon.
gt;
gt;Any help would be great.
gt;
gt;Thanks

Check out the Data/Text-to-columns wizard. Just specify the semicolon as the
separator.
--ron