Format certain words in one Cell.

[Bigmac4]

Hi All,

Hope you can help, i have 1 cell with something like -

Oranges, Pineapples, Pears, Raspberry, Strawberry, Apple .

What i would like to do is to automatically Bold certain words, so it would look like this

Oranges, Pineapples, Pears, Raspberry, Strawberry, Apple

Is this possible using VBA? i have a list of 10 items that i would like to Bold in the cell but the data in the cell will change so it needs to be more automatic rather than Find/replace or select and format?

Thank you in advance for any help offered.

Office 365 Apps for enterprise

 

[Peter_SSs]

Welcome to the MrExcel board!

but the data in the cell will change

Does that mean that the cell contains a formula?

Office 365 Apps

Please put that in your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Bigmac4]

Yes it contains a TextJoin formula

 

[Peter_SSs]

Yes it contains a TextJoin formula

You cannot bold format individual parts of a formula result. It is all or nothing I'm afraid.

Thanks for updating your version details.

 

[Bigmac4]

Thank you, thought as much. Is it possible to concant while keeping the format of the cells being joined?

 

[Peter_SSs]

Is it possible to concant while keeping the format of the cells being joined?

No, it is not possible to bold format individual parts of a formula result.

 

[Bigmac4]

How could it be done if it was not a formula? so it was just written as text in a cell? Thank you.

 

[Joe4]

How could it be done if it was not a formula? so it was just written as text in a cell? Thank you.

Simply edit the entered values, selecting the pieces you want to bold, one at a time, and click the bold button.

 

[Bigmac4]

Thanks Joe, is there a way to do it via a formula or vba?

 

[Joe4]

Thanks Joe, is there a way to do it via a formula or vba?

You have already had the formula question answered.

For VBA, see here: Excel VBA: Change Font Color for Part of Text (3 Methods) - ExcelDemy