Function to retain text format

Hi,

Anyone knows to create function to retain text formatting.

I found code on net but seem it does not work on me.
https://excel.tips.net/T003213_Match...atenating.html

PHP Code: 

Function FmtText(rng As Range)
    Application.Volatile
    FmtText = rng.Cells(1).Text
End Function 


any ideas?

You already have a thread running on this issue: https://www.excelforum.com/excel-pro...me-format.html

This thread is now closed as a duplicate. Duplicate threads are not allowed here. Please be patient and continue in the original thread.