hi

any reason why you don't want to use text to columns as it would probably be
the easiest option - are you looking for formulas or a vba solution?

Cheers
JulieD

<jajoseph@zoominternet.net> wrote in message
news:1107707119.371429.79870@l41g2000cwc.googlegroups.com...
> Is there a way to do it without using Text to Columns in the menu ba
>