Previous Topic Next Topic

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 23541 Registration date Sunday June 8, 2008 Status Contributor Last seen June 6, 2025 - 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

Answer 1 / 1
yg_be Posts 23541 Registration date Sunday June 8, 2008 Status Contributor Last seen June 6, 2025 5
Nov 24, 2016 at 04:07 PM
I believe you can do that using VBA.

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses