Results 1 to 8 of 8

Thread: plz help.. which formula

  1. #1

    Smile plz help.. which formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi.. i'm working with alot of data i must input but i dont know what formula i can use.. here's the sample case:

    A1: The (B1) box in room number (C1) will be sent to (D1)

    B1: red
    C1: 6
    D1: US

    i need to have the result on F1: The red box in room number 6 will be sent to US

    what formula should i put in F1?


    thanks alot

  2. #2
    Acolyte rollis13's Avatar
    Join Date
    Feb 2013
    Location
    Cordenons
    Posts
    31
    Articles
    0
    Excel Version
    2016 64bit
    This could be a (very simple) solution:

    =LEFT(A1,4) & B1 & MID(A1,9,20) & C1 & MID(A1,33,17) & D1

  3. #3
    Try

    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(B1)",B1),"(C1)",C1),"(D1)",D1)

  4. #4
    seems that it will work if the text in A1 have the same number of charctr.. in my case text can be vary, so i need a formula that if text in A1 contain "(B1)" it will be replaced with text in B1 itself..

    thanks

  5. #5
    @bob: i've tried your suggestion but didn't work.. hopefully u have other suggestions

    thanks

  6. #6
    Acolyte rollis13's Avatar
    Join Date
    Feb 2013
    Location
    Cordenons
    Posts
    31
    Articles
    0
    Excel Version
    2016 64bit
    Mine was somewhat silly but Bob's formula works (tested it).
    Last edited by rollis13; 2014-02-17 at 08:41 PM.

  7. #7

    CONCATENATE will work as well

    Id the sentence never changes then the CONCATENATE equation is simple...

    =CONCATENATE("The ",B1," box in room number ", C4," will be sent to ",A5)

  8. #8
    Bob, yes it worked.. thx alot

Tags for this Thread

Posting Permissions

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