hello Sir
would you please help me to write code to add underline to one or more of word inside a cell ..for example
in cell
g1, h1, i1, j1, k1
i want to get the value of all that cells and put it in cell
a1
and i want to add underline to the cel
h1
and the cell
j1
h1
and
j1
are a number has format like ...1,000,000
value of cells
g1, i1, k1
are words
so how can i get all this cells value and put all in one cell
a1
with underline for only
h1
and
j1
i wish some one can help me
thanks for all
What I have tried:
i'm trying to get value of cells (for example
G1, H1, I1
and
K1
) and put it in one cell with underline to cell
H1
and
J1
like as showing bellow :
G1 H1 i1 J1 K1
word1 1,000,000 word2 2,000,000 word3
i want to use Excel Formula or Excel VBA to get the result as showing below
word1 1,000,000 word2 2,000,000 word3
withunderline for H1 and J1