Excel Formula Help

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

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

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

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.

 

try 'your words here' after the formula and see if that works, I doubt it but it might.

 

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!

 

Can you not Concatenate it?

 

Does seem to work after trying it again, eg...

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

Shows as "Total is 4 TestTest"

 

Yeah After I had done my first reply to you, I suddenly thought ' ' or " " might aswell try it. Havent used Excell properly since 99

 

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

is the correct Formula

 

...which is the same as what nxplosive wrote, but in a function.

 

You know what. Ignore me.

I'm having a bad day.......Apologies to all

 

It did have helpful info you now know what you wrote was the same as nxplosive but as a function.

 

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