Opposite of Concatenate

[dkubiak]

Can I do some sort of un-concatenate? For example, if I have the following text in cell A1:

June, August

And I want to change it so that I have June in cell A2 and August in cell A3, is there a function to do that? The comma placement is consistent in all of my data.

Thanks!

P.S. I'm using 2007 - not sure if that matters.

 

[al_b_cnu]

hi,

Try Data / Text to columns

 

[ellen_dms]

If always the same # of digits, you can try:

=Left(
=Mid(
=Right(

For all of the formulas you need to enter a number of digits you want to show....