What are the other set of values? A3-A4, A5-A7,... or B1-B2, C1-C2,... or
what? You'll need a VBA sub.
Stefi
€˛evelin via OfficeKB.com€¯ ezt Ć*rta:
hi friends
i want to concatenate the value in cell A1 AND A2 AND PUT IN A1.
SUPPOSE " string1" is a string variable
EG. SUPPOSE A1 contains "office" and A2 contains "KB" , THEN variable
string1=OfficeKB
and assign to A1.
THIS MUST BE DONE FOR A SET OV VALUES
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200912/1
.