macro to convert text string
 

Or you can use Data / Text To Columns / Comma as delimiter. Make sure you have enough blank
columns to the right of your data to take the new data.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"Josh" wrote in message
om...
My macro skills are a bit rusty, so I need some help on this one. An
example of the problem at hand: I would like to be able to convert a
text string in one cell([williamson, josh] or [josh williamson]) to
two different cells (williamson in cell 1 and josh in cell 2.

Thanks for the help

macro to convert text string
 

Thanks to the both of you. I used and benefited from both methods.

"Ken Wright" wrote in message ...
Or you can use Data / Text To Columns / Comma as delimiter. Make sure you have enough blank
columns to the right of your data to take the new data.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"Josh" wrote in message
om...
My macro skills are a bit rusty, so I need some help on this one. An
example of the problem at hand: I would like to be able to convert a
text string in one cell([williamson, josh] or [josh williamson]) to
two different cells (williamson in cell 1 and josh in cell 2.

Thanks for the help