Incorporating the text formating when Formula in used [Closed]

Report
Posts
6
Registration date
Monday October 24, 2016
Status
Member
Last seen
November 24, 2016
-
Posts
15215
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 17, 2021
-
Hello Guys,

In Cell A1, the text is "abc" (Note that "abc" is underlined). If i choose cell B1 and apply a formula as "=A1", the cell B1 shows "abc" without the underline. Is there a way to incorporate the cell formating like underlines/bold via this formula?

Any guidance is appreciated. Thanks :)

1 reply

Posts
15215
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 17, 2021
4
I believe you can do that using VBA.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!