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