Use the Text-to-Columns feature. You can use a delimiter of "_" and treat
consecutive delimiters as one.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"chuck" wrote:

I have excel 2007 - can't find any useful web site for support at microsoft.
I'm not sure how to navigate all of the support web sites. And then there
is Bing that keeps showing up?



I have data like "12.99__13.49__12.78_.00_234.00" in a cell - I need to
unstring the text into 5 numeric cells using formulas? I've not been able to
figure this out.


Any help would be appreciated.

Thank You