98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Unit text strings in formula cells
Unit text strings in formula cells
Resolved · High Priority · Version 2003
Liz has attended:
SharePoint course
Unit text strings in formula cells
We have a function in a cell (=SUM(G17+G22+G28+G33+G38+G51))
Is it possible to somehow add a text string to say what the resulting figure represents (e.g. car parking spaces)
Thanks
RE: unit text strings in formula cells
Hi Liz
Thank you for your question.
You can do this by using the CONCATENATE function.
If you enter the following into the cell where the total is currently showing:
=concatenate(SUM(G17,G22,G28,G33,G38,G51)," car parking spaces")
Note the space between the " and the word car - otherwise you will have the word car right next to the total without a gap between them.
I hope this helps.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Concatenating Results of FormulasTo concatenate the results of formulas simply add the "&" after the formula or function closing bracket. |