View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.