Appending Text to a Cell Value

[Pappey]

I have cells with a Formula, =PRODUCT(F4, H4). I want to manually append a
piece of text to the value, so that I can use selected cell values in a sum
statement

Current:
15 45 75 105
15 45 75 105

Wanted:
15 45S 75 105S
15S 45 75S 105

I haven't been able to fid any examples of this in any of the support or
help forums.

 

[Duke Carey]

I must be a bit dense today & can't figure out what you want to accomplish.
Could you please restate your question with a little more background?

 

[Mike Fogleman]

=PRODUCT(F4, H4)& "S"

Mike F

 

[Ron Rosenfeld]

I have cells with a Formula, =PRODUCT(F4, H4). I want to manually append a
piece of text to the value, so that I can use selected cell values in a sum
statement

Current:
15 45 75 105
15 45 75 105

Wanted:
15 45S 75 105S
15S 45 75S 105

I haven't been able to fid any examples of this in any of the support or
help forums.

You could custom format the cells:

Format/Cells/Number/Custom Type: 0\S


--ron