Formatting a piece of the text in the formula box

I want to use VBA to insert text into a cell. The problem is that I want the inserted text to consist out of one character formatted in calibri, a space bar and then another character (D) formatted Wingdings 3 to make it appear as a double arrow. Is this possible?

you need to change a Target range and insert only first character

Please Login or Register  to view this content.

Thank you both! The only issue is that the first value can be 1 or 10000. So basically the number of characters where the wingdings part starts is variable.

It is always the last character so the code works wonderfully. Thanks again!