ExcelBanter - Concatenate

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Concatenate (https://www.excelbanter.com/excel-worksheet-functions/212640-concatenate.html)

PAL

Concatenate

I am using the following formula:

=CONCATENATE(Sheet1!B2,"(",Sheet1!B15,")")

The reference cell, "Sheet1!B15", is formatted as a percentage. The output
that I get from this formula is:

"4(0.0615384615384615)"

How do I get the "0.06..." to come out as 6% so it looks like this:

"4(6%)"

Thanks.

Gary''s Student

Concatenate

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

--
Gary''s Student - gsnu200817

Rick Rothstein

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

All times are GMT +1. The time now is 08:43 AM.