BG wrote...
Can anyone tell me how to combine text and numbers in the same cell so that
only the number is a value e.g. Fuel at 17 ltrs/hr This would be entered into
one cell but could be used as part of a formula where only the number 17 is
used?

Try the number format

"Fuel at "0" ltrs/hr"

which will bracket the number value with the text "Fuel at " before
and " ltrs/hr" after.

Alternatively, if this were in a table, use a column heading like Fuel
Flow Rate (ltrs/hr). If it weren't a table, consider using a long
label in the cell to the left or right of the cell containing the
number.