Spilt value and currency

[Guest]

I have both value and currency type in a single cell, currency formatted
cell, How do i split up to get Value and currency type in two different cells?

 

[Guest]

Format the cell as number (not as currency), and put this formula in the cell
you want to have the currency symbol in:

=LEFT(DOLLAR(0,0),1)

This works if your Windows Regional Settings' currency symbol is $ or £ or
any one digit symbol standing before the number.

In my Hungarian XL version the currency symbol is a two digit string
standing after the number (e.g. 100 Ft), in this case =RIGHT(DOLLAR(0,0),2)
is the appropriate formula. Adjust the formula according to your Regional
Settings!

Regards,
Stefi


„AJ†ezt írta:

 

[Guest]

If F25 contains:

12 dollars
then
=--LEFT(F25,FIND(" ",F25,1)-1)
will return
12

and
=RIGHT(F25,LEN(F25)-FIND(" ",F25,1))
will display
dollars