Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jun 2002
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Concatenating (Excel 2000)

    Hi,
    StatusMsg = _
    "=CONCATENATE(TEXT(RC[1],""mm/dd""),"": Vendor Confirmed PO. "",R[-7]C)"

    This Variable (StatusMsg) takes the date stored in the adjacent cell on the same row (hence RC[1]), changes it to text, then, concatenates it with the text "Vendor Confirmed PO", finally (and here is the problem), it also concatenates it with the contents of the cell stored 7 rows above it.

    This works if I assume I am always on Row 10. I know longer want to assume I am on Row 10. The value, though, is always stored in Row 3 of that column. What is the syntax I should use? Hope that made sense!

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenating (Excel 2000)

    Try
    StatusMsg = _
    "=CONCATENATE(TEXT(RC[1],""mm/dd""),"": Vendor Confirmed PO. "",R3C)"

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Concatenating (Excel 2000)

    Cat

    The syntax would be to change the -7 to what ever row number you need to get to the value you need. You can do that by an offset or manually if you prefer.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    Lounger
    Join Date
    Jun 2002
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenating (Excel 2000)

    Thank you for your quick reply. This is what I needed.
    Since I found this site, I have been "amazing" my bosses. Again, thank you!

Posting Permissions

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