An alternative method is to format Cell Number Custom to something like

General" meters" The value can be used directly.
--
Gary''s Student


"JMB" wrote:

If

A1 = 6 meters
A2 = 11.9 meters

=VALUE(LEFT(A1,SEARCH(" ",A1,1)-1))+VALUE(LEFT(A2,SEARCH(" ",A2,1)-1))

"Bob Martin" wrote:

I want to be able to have a number and a word in the same cell, but still be
able to use formulas to add, subtract, ect. to the number.
For example: I have 6 meters in cell A1 and want to add 11.9 meters