+ Reply to Thread
Results 1 to 2 of 2

reference the result of a formula in a text formatted cell

  1. #1
    jpwinston
    Guest

    reference the result of a formula in a text formatted cell

    I am trying to refernce the result of a formual/calculation cell in a cell
    that is formatted for text (the spread sheet contains part numbers, I need
    to refernce them as text becasue there are other characters besides numbers
    in them. In this case, a portion of the part number is the result of a
    calculation (performed in another cell). I need to append the result of the
    calculation to the end of the text string(numbers and symbols).

  2. #2
    Max
    Guest

    Re: reference the result of a formula in a text formatted cell

    Try Debra's nice coverage on combining data at her:
    http://www.contextures.com/xlCombine01.html

    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1° 22' N 103° 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    "jpwinston" <jpwinston@discussions.microsoft.com> wrote in message
    news:EEBAEE9A-B9BA-4DC5-9A2F-689875D557D4@microsoft.com...
    > I am trying to refernce the result of a formual/calculation cell in a cell
    > that is formatted for text (the spread sheet contains part numbers, I

    need
    > to refernce them as text becasue there are other characters besides

    numbers
    > in them. In this case, a portion of the part number is the result of a
    > calculation (performed in another cell). I need to append the result of

    the
    > calculation to the end of the text string(numbers and symbols).




+ 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