Appending Text to a Cell Value
 

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.

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?

"Pappey" wrote:

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.

=PRODUCT(F4, H4)& "S"

Mike F
"Pappey" wrote in message
...
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.

On Fri, 25 Mar 2005 11:29:01 -0800, Pappey
wrote:

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