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 24281 Status Contributor - 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 24281 Status Contributor 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