extract data from cells

[Nicole L.]

How can I extract into separate cells the following type of data that's
currently in one cell of a spreadsheet (of course there are many entries just
like this so I want to automate how to extract out into 2 cells that which is
currently in one cell)

AB= smithj, CD= John Smith

Where "AB=" and "CD=" and the comma are all constant in all the cells?

I just want that first half (before the comma) extracted into a cell and the
second half into a cell... but for a huge spreadsheet full of rows with that
data in it.

Thanks for any info on code/formula/process for this!

[Peo Sjoblom]

Data>text to columns delimited and comma as delimiter, make sure the first
column to the right is empty

Regards,

Peo Sjoblom

"Nicole L." <[email protected]> wrote in message
news:[email protected]...
> How can I extract into separate cells the following type of data that's
> currently in one cell of a spreadsheet (of course there are many entries
just
> like this so I want to automate how to extract out into 2 cells that which
is
> currently in one cell)
>
> AB= smithj, CD= John Smith
>
> Where "AB=" and "CD=" and the comma are all constant in all the cells?
>
> I just want that first half (before the comma) extracted into a cell and
the
> second half into a cell... but for a huge spreadsheet full of rows with
that
> data in it.
>
> Thanks for any info on code/formula/process for this!
>

[Ken Wright]

Do you want the AB= and the CD= bits?

When you say constant I assume you mean all entries are initially preceded
with AB= etc.

Select all your data and do Edit / Replace / Replace what = 'AB= ' (No
quotes but include the space), replace with just leave blank. Now repeat
for CD=

Select column of data, do Data / Text To Columns / delimited, tick comma hit
OK

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Nicole L." <[email protected]> wrote in message
news:[email protected]...
> How can I extract into separate cells the following type of data that's
> currently in one cell of a spreadsheet (of course there are many entries
just
> like this so I want to automate how to extract out into 2 cells that which
is
> currently in one cell)
>
> AB= smithj, CD= John Smith
>
> Where "AB=" and "CD=" and the comma are all constant in all the cells?
>
> I just want that first half (before the comma) extracted into a cell and
the
> second half into a cell... but for a huge spreadsheet full of rows with
that
> data in it.
>
> Thanks for any info on code/formula/process for this!
>