Format specific text within a cell created by a formula

[Miraz_Sarder]

Hi

I need to format a part of texts within a cell that have created by a formula. I want to format specific text not the entire cell. Is there any way?

Thanks

[NickyC]

Hi you can format parts of a string

aaabbb

but if your cell entry is a number or a formula, I don't think it can be done

[Miraz_Sarder]

hi @NickyC

Thanks. Is there any vba code to do the job?

[NickyC]

not that I'm aware, unless you want to copy the result of the formula to another cell or overwrite the formula with its value, and even that will only work if the result is not a number

or, if you want to see the components of the formula, convert it to a string eg

'=22+44