View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Combining 2 percentages into one cell and displaying as % format

Hi,
I assume that your percentages are in A1 and B1 so in C1 emter

=A1&" / "&B1

"RLind" wrote:

I have once cell that is 75% and one cell that is 25%.

I would like to combine the two into one cell that looks like this "75% / 25%"

Concatenate does not seem to work for me since these are not text so it does
not display as %s.

Thanks for your help!