Forum home » Delegate support and help forum » Microsoft Excel Training and help » Unit text strings in formula cells

Unit text strings in formula cells

ResolvedVersion 2003

Thu 29 May 2008, 15:19 Delegate Liz said...

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

Fri 30 May 2008, 15:42 Trainer Amanda said...

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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

Unit text strings in formula cells

Unit text strings in formula cells

RE: unit text strings in formula cells

Excel articles

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010