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.
--
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

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.

"Luke M" wrote:

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

Copy column A to B then do datatext to columns on B


Gord Dibben MS Excel MVP

On Tue, 19 Jan 2010 12:46:01 -0800, chuck
wrote:

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.

"Luke M" wrote:

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

Which is EXACTLY what will happen if you follow the suggestion.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"chuck" wrote in message
...
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.

"Luke M" wrote:

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