+ Reply to Thread
Results 1 to 3 of 3

Spilt value and currency

  1. #1
    AJ
    Guest

    Spilt value and currency

    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?

  2. #2
    Stefi
    Guest

    RE: Spilt value and currency

    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?


  3. #3
    Gary''s Student
    Guest

    RE: Spilt value and currency

    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?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1