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.
|