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