Not sure how to apply this.
Outcome is to use number from this cell and number from another cell in a
formula of a third cell. When I applied this suggestion to two cells and
then created a formula in third cell I still had error.

However, Ron Coderre's reply suggestion helped satisfy my needs.

THANKS.

"Don Guillett" wrote:

=1*2017 & " total pps"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"paulg" wrote in message
...
I would like to avoid using two cells to represent the following:
2017 TOTAL PPs. (all in one cell)
I would like to use only the number part of the cell contents in a
formula.
Can it be done?