Copy Partical content of cell based on value

Lenovo / 7675h7u
May 20, 2009 at 05:57:59
Specs: Microsoft Windows XP Professional, 2.095 GHz / 998 MB
I need to take the contents of Column A and copy to empty cells when I find a ";". Here is an example of how Column A Row 1 could look: apple; orange; grapes; apple-orange. The result I need is apple orange grapes and apple-orange would each need to appear in a separate cell. It could be in column A or copied to Column B. If we copied to Column B then this is what I would want to see Column B row 1 apple, Column B row 2 orange, Column B row 3 grapes, and Column B row 4 apple-orange. I need to do this for every row in Column A.

See More: Copy Partical content of cell based on value

Report •


#1
May 20, 2009 at 06:44:21
Separating the data is easy:

Select Column A
Click on Data...Text to Columns...Delimited...Next
Put a ; in the Other box and click finish.

Your description regarding placing the data in B1:B4 confuses me a bit.

You said: I need to do this for every row in Column A.

If the four parts of A1 will end up in B1:B4, where will the fours parts of A2 end up? Obviously they can't end up in B2:B5, so where will they go?


Report •

#2
May 20, 2009 at 07:21:02
That worked. The data was copied to the cells b, c, etc (depending on how many ";" appeared in the first cell) of the same row. Thanks

Report •

#3
May 20, 2009 at 08:05:15
I'm glad I could help.

If you need the data in each row to be placed in columns, you can do a Copy...PasteSpecial...Transpose.


Report •

Related Solutions


Ask Question