Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2005
    Location
    Jacksonville, North Carolina
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text from 2 cell to 1 cell (2003)

    ='CLM-';[GJ Form.XLW]COST vending survey!$A$6;'-';[GJ Form.XLW]COST vending survey!$B$6;'-000-000'
    Is there a way to take text from one sheet in move then one cell to another sheet in to one cell and add other text.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Text from 2 cell to 1 cell (2003)

    Are you looking for:

    ="CLM-" & '[GJ Form.XLW]COST vending survey'!$A$6 & "-" & '[GJ Form.XLW]COST vending survey'!$B$6 & "-000-000"


    Steve

  3. #3
    New Lounger
    Join Date
    Jun 2005
    Location
    Jacksonville, North Carolina
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text from 2 cell to 1 cell (2003)

    Thank that put me the right area this is going to save me a lot of time.

Posting Permissions

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