Copying data from 2 cells into 1
 

I have a different formula in 2 different cells, and I would like to combine
the responses into 1 cell. Q92 has a percentage output and R92 has a text
output. I would like E92 to be the % from Q92 and the text from R92 so that
the result in E92 is 6% Net 75, for one example. Any advice would be
appreciated. Thanks.

Copying data from 2 cells into 1
 

Try this:

=TEXT(E92,"0%") & " " & R92

Hope this helps.

Pete

"Taylor" wrote in message
...
I have a different formula in 2 different cells, and I would like to
combine
the responses into 1 cell. Q92 has a percentage output and R92 has a text
output. I would like E92 to be the % from Q92 and the text from R92 so
that
the result in E92 is 6% Net 75, for one example. Any advice would be
appreciated. Thanks.

Copying data from 2 cells into 1
 

Thanks, Pete. That helped.

"Pete_UK" wrote:

Try this:

=TEXT(E92,"0%") & " " & R92

Hope this helps.

Pete

"Taylor" wrote in message
...
I have a different formula in 2 different cells, and I would like to
combine
the responses into 1 cell. Q92 has a percentage output and R92 has a text
output. I would like E92 to be the % from Q92 and the text from R92 so
that
the result in E92 is 6% Net 75, for one example. Any advice would be
appreciated. Thanks.