Incorporating the text formating when Formula in used

Closed
adikademani Posts 5 Registration date Monday October 24, 2016 Status Member Last seen November 24, 2016 - Nov 24, 2016 at 07:13 AM
yg_be Posts 22679 Registration date Sunday June 8, 2008 Status Contributor Last seen April 14, 2024 - Nov 24, 2016 at 04:07 PM
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 :)
Related:

1 response

yg_be Posts 22679 Registration date Sunday June 8, 2008 Status Contributor Last seen April 14, 2024 5
Nov 24, 2016 at 04:07 PM
I believe you can do that using VBA.
0