1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel Formula Help

Discussion in 'Software' started by nXPLOSi, Jan 4, 2008.

  1. nXPLOSi

    nXPLOSi Terabyte Poster

    2,874
    30
    151
    Hi guys,

    Quick question really, i've got this formula..

    ="EFFECT FROM "&TEXT(Trade_Date,"dd mmm yyyy")

    Is it possible to add text on the end of it in the same column?

    No idea if its possible, or how it would be done. Sorry if its a stupid question :oops:
     
    Certifications: A+, Network+, Security+, MCSA 2003 (270, 290, 291), MCTS (640, 642), MCSA 2008
    WIP: MCSA 2012
  2. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,283
    254
    329
    I havent used Excel for a long time but I don't think you can because adding text would invalidate your formula and would return an error, you could always put the text in the next column then see if you can merge the two columns together, so it looks like one.
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  3. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,283
    254
    329
    try 'your words here' after the formula and see if that works, I doubt it but it might.
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  4. nXPLOSi

    nXPLOSi Terabyte Poster

    2,874
    30
    151
    I think I figured it out, seems simple now but its just.. & " Text" on the end. At least it seems to work at the moment, lets hope it works for this end user im about to call! :)
     
    Certifications: A+, Network+, Security+, MCSA 2003 (270, 290, 291), MCTS (640, 642), MCSA 2008
    WIP: MCSA 2012
  5. DiscoPistol

    DiscoPistol Bit Poster

    13
    0
    9
    Can you not Concatenate it?
     
    WIP: MOS Master
  6. nXPLOSi

    nXPLOSi Terabyte Poster

    2,874
    30
    151
    Does seem to work after trying it again, eg...

    ="Total is "&SUM(A12+A13) & " TestTest"

    Shows as "Total is 4 TestTest"
     
    Certifications: A+, Network+, Security+, MCSA 2003 (270, 290, 291), MCTS (640, 642), MCSA 2008
    WIP: MCSA 2012
  7. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,283
    254
    329
    Yeah After I had done my first reply to you, I suddenly thought ' ' or " " might aswell try it. Havent used Excell properly since 99 :oops:
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  8. DiscoPistol

    DiscoPistol Bit Poster

    13
    0
    9
    =CONCATENATE("Total is ",SUM(A12:A13)," Test Test")

    is the correct Formula
     
    WIP: MOS Master
  9. Tinus1959

    Tinus1959 Gigabyte Poster

    1,539
    42
    106
    ...which is the same as what nxplosive wrote, but in a function.
     
    Certifications: See my signature
    WIP: MCSD, MCAD, CCNA, CCNP
  10. DiscoPistol

    DiscoPistol Bit Poster

    13
    0
    9
    You know what. Ignore me.

    I'm having a bad day.......Apologies to all
     
    WIP: MOS Master
  11. Rob1234

    Rob1234 Megabyte Poster

    782
    24
    69
    It did have helpful info you now know what you wrote was the same as nxplosive but as a function.
     
    Certifications: A few.
  12. nXPLOSi

    nXPLOSi Terabyte Poster

    2,874
    30
    151
    Disco, you post was helpful mate, if I hadn't of come up with the other way first, I would have used the one you provided for sure :)
     
    Certifications: A+, Network+, Security+, MCSA 2003 (270, 290, 291), MCTS (640, 642), MCSA 2008
    WIP: MCSA 2012

Share This Page

Loading...