Unstring in excel

  • Thread starter Thread starter chuck
  • Start date Start date
C

chuck

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
 
Use the Text-to-Columns feature. You can use a delimiter of "_" and treat
consecutive delimiters as one.
 
Hey Luke thanks for the tip. I think you missed one detail however. The
data 123.56__3456.22__126.88 is in a single cell say a1. I need cells
b1,c1,d1 to be equal 123.56,3456.22 and 126.88 respectively. I must use a
formula - text to columns is not appropiate for this application. I need
some type of unstring function I think.
 
Back
Top