Unstring in excel
 

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

Unstring in excel
 

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

Unstring in excel
 

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

Unstring in excel
 

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

Unstring in excel
 

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