+ Reply to Thread
Results 1 to 2 of 2

Displaying the results of multiple formulas in a single cell.

  1. #1
    gallegos1580
    Guest

    Displaying the results of multiple formulas in a single cell.

    This is probably really simple but for some reason I can't figure it out.

    Here is the problem I have one cell that contains a long ID#
    And one Call that has a quantity and I-d like to show a range of values
    based on that quantity but only display the last few characters

    For Example

    A1: 3ex21h200 - ID#
    B1: 45 - Quantiny

    Using the =RIGHT(A1,4), I can show just the h200
    What I'd like to show is a range that will automatically populate based on
    the quantity. And not have to manually imput anything!

    For Example

    C1: h200 - h245

    So far all I can do is get the cell to show the 200 anything I type onto the
    end of that formula gives me a formula error, I'm sure there is some way to
    close to formula and add tex or other characters, like the hyphen, but I
    don't know haw any help would be greatly appreciated. Thanks!



  2. #2
    JulieD
    Guest

    Re: Displaying the results of multiple formulas in a single cell.

    Hi

    how about
    =RIGHT(A1,4) & " - " & MID(A1,LEN(A1)-3,1) & RIGHT(A1,3)+B1

    Cheers
    julieD

    "gallegos1580" <gallegos1580@discussions.microsoft.com> wrote in message
    news:C9D35471-D76F-4C0C-A695-B082EE373113@microsoft.com...
    > This is probably really simple but for some reason I can't figure it out.
    >
    > Here is the problem I have one cell that contains a long ID#
    > And one Call that has a quantity and I-d like to show a range of values
    > based on that quantity but only display the last few characters
    >
    > For Example
    >
    > A1: 3ex21h200 - ID#
    > B1: 45 - Quantiny
    >
    > Using the =RIGHT(A1,4), I can show just the h200
    > What I'd like to show is a range that will automatically populate based on
    > the quantity. And not have to manually imput anything!
    >
    > For Example
    >
    > C1: h200 - h245
    >
    > So far all I can do is get the cell to show the 200 anything I type onto
    > the
    > end of that formula gives me a formula error, I'm sure there is some way
    > to
    > close to formula and add tex or other characters, like the hyphen, but I
    > don't know haw any help would be greatly appreciated. Thanks!
    >
    >




+ 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