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

<Data <Text to Columns...
Then, select "Delimited", hit next, and check Semi Colon


--
Regards,
Dave


"bsantona" wrote:

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

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

In article ,
"bsantona" wrote:

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

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: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=495530

On Thu, 22 Dec 2005 07:49:02 -0800, "bsantona"
wrote:

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

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