separate numbers and letters

**excelmax** · 06-09-2008, 12:35 PM

I have a very common problem; I looked up several formulas but none of these worked.
I want to seperate numbers and letters like the following:
29.266,20 Mio EUR

so that I only have the 29.266,20 left; wthout the currency!

can anybody help me?

**NBVC** · 06-09-2008, 12:52 PM

tRY:

=LEFT(A1,FIND(" ",A1))+0

**excelmax** · 06-09-2008, 02:19 PM

hi,

i'm sorry; it doesn't work;
could the comma and the point be a problem?

**NBVC** · 06-09-2008, 02:23 PM

If you have European Excel.. then maybe...

=LEFT(A1;FIND(" ";A1))+0

**excelmax** · 06-09-2008, 04:04 PM

sorry, it doesn't work either!
i've an american version!
I had another formula, which worked quiet well, but only for
items where the letters stand in front of the numbers like:
(Millions)111,973.400

=RIGHT(C95,LEN(C95)-MIN( FIND({0,1,2,3,4,5,6,7,8,9},C95&"0123456789"))+1)

perhaps, you can change this formula so that it works the other way round
(first numbers and then letters)?

Thanks in advance!