I have a cell in Numbers which displays a value generated by a simple formula (A2 x .25).
How can I edit the formula to add text before and after the value?
Example: I want to add the letter X in front of 0.09375 followed by a space and F5 so it reads:
X0.09375 F5
This should do it:
The formula calculates the value. The concatenation operators (&) join the "X" prefix, the formula result, and the " F5" suffix into a single text string.
When entering the formula, use an asterisk ( * ) in place of the multiplication sign. Numbers will automatically replace the * with the multiplication sigh, but will not recognize that sign (or a lower case letter x) that is typed into the formula directly.
Regards,
Barry
This should do it:
The formula calculates the value. The concatenation operators (&) join the "X" prefix, the formula result, and the " F5" suffix into a single text string.
When entering the formula, use an asterisk ( * ) in place of the multiplication sign. Numbers will automatically replace the * with the multiplication sigh, but will not recognize that sign (or a lower case letter x) that is typed into the formula directly.
Regards,
Barry
Thanks Barry! That worked perfectly.
Chris
Adding text to a value in Numbers
