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
17136
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
October 23, 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
17136
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
October 23, 2021
5
I believe you can do that using VBA.