I'm wondering if it possible to use format rule for a part of the text.
So i got the following text in a column:
="Some text "&[Column 1]&" Some text "&[Column 2]&" Some text 3"
( I eat [meat balls] and [vegetables] every Monday)
I want to apply the format rule for a [Column 2] text-part.
If I use Formate rule for a Column 2 , it won't work after CONCATENATE() function.
Please help if there any trick to reseave the following result:
="Some text "&[Column 1]&" Some text "&[Column 2]&" Some text 3"
( I eat [meat balls] and [vegetables] every Monday)
User | Count |
---|---|
16 | |
9 | |
9 | |
7 | |
3 |