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?
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?
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:
> 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?
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
--
Gary's Student
"AJ" wrote:
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks