I'm confused by the conditional formatting piece?
Which of the cells has conditional formatting?
If all the cells, then do they all have the same criteria?
If so, and the various criteria produce different resulting formats (based on the different values shown in each cell), what is the order of priorty for the applied formats to A1?
Also, what is an example of what the existing value(s) would be for the two percentage formatted entries in the concatenated string?
Correction/clarification: what is an example of the EXISTING values in data2 and data5 and do the values already represent percentages in need of the symbol, or would they need tobe multiplied by 100 and then have the symbol attached?
For example:
Data2 has a value of .1234, would normally format to a percentage of 12.34%
or, is .1234 already in a percent and need to be rounded to 0.12%
Bookmarks