Thread: Concatenate
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Concatenate
A little more compact...

=Sheet1!B2&TEXT(Sheet1!B15,"(0%)")

--
Rick (MVP - Excel)


"Gary''s Student" wrote in message
...
=CONCATENATE(Sheet1!B2,"(",TEXT(Sheet1!B15,"0%")," )")

--
Gary''s Student - gsnu200817

Reply With QuoteReply With Quote