I had a completed worksheet and someone wanted the text to be uppercase. I tried =uppercase(a1:m56).
2007-03-08 11:51:15 · 2 answers · asked by smartyboots 2 in Computers & Internet ➔ Other - Computers
seems that you want to concatenate text in one column before applying the uppercase..
suppose A1, B1, C1 and D1 is your column and row
value of A1 is joseph, value of B2 is hahn
A1
joseph
B1
hahn
your formula for C1 is
=CONCATENATE(A1, " ", B1)
result
C1
joseph hahn
your fomula for D1
=UPPER(C1)
result
D1
JOSEPH HAHN
Hope it helps!
2007-03-15 05:20:02 · answer #1 · answered by Ω™ 3 · 0⤊ 0⤋
Well, I cant tell if this worksheet is for personal use or for web use, but if it is for personal use, I am pretty sure that you can select all and go to Format > Change Case (or something to that effect) > UPPERCASE
2007-03-08 19:55:53 · answer #2 · answered by armrest4160 2 · 0⤊ 0⤋