how to bold part of the value in cells if numeric

Morning all experts

looking help in marocrs to bold the string in cells if numeric as example :

PROFITS FUND WAREHOUSE ROOM 3 5 24 F TOWER 1

to
PROFITS FUND WAREHOUSE ROOM 3 5 24 F TOWER 1

there in worksheet columns A

can it be using macros or formuls ?

Thanks your help

Originally Posted by MrShorty

Use the Characters object: https://msdn.microsoft.com/EN-US/lib.../ff194098.aspx
https://msdn.microsoft.com/en-us/lib.../ff198232.aspx

Thanks for advised
i would going to try ..

If the cell is pure numeric value or formula result, you can not change the partial font attribute unless you change it to String.

But your data looks like Text anyway...