G
Guest
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!
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!