functions

[bsantona]

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

[JE McGimpsey]

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

In article <[email protected]>,
"bsantona" <[email protected]> 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

[David Billigmeier]

<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

[SteveG]

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

[Ron Rosenfeld]

On Thu, 22 Dec 2005 07:49:02 -0800, "bsantona"
<[email protected]> 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