Forum Discussion
Excel - CONCATENATE
I am trying to include a number in text but when I use the CONCATENATE function I lose the comma - eg 123,456 converts to 123456. Is there a way I can retain the comma?
Thank you Colin
My problem is that I am trying to insert a numbers into a body of text and have been unable to apply your solution to this. For instance in "The company's sales were £300,000, purchases £160,000 and gross profit £140,000." what formula should I use? Assume that the figures are in cells A1, A2 and A3 respectively.
Many thanks
Colin
I have now solved the problem by using a combination of the CONCATENATE and TEXT functions. Many thanks for your help.