V
via135
hi all!
is there any way to combine the data in two cells (row-wise) in xl?
for example
A1 - date; A2 - narration (text); A3 - amount
B1 - blank; B2 - narration (text); B3 - blank
C1 -blank; C2 - narration (text); C3 - blank
now i want
A1 - date; A2 - combined text of A2,B2&C2; A3 - amount
after converting the three records into a single one, i don't need row
B & C.
this is required simply because to reduce the records and make th
worksheet size to 1/3.
can anyone help me?
-via13
is there any way to combine the data in two cells (row-wise) in xl?
for example
A1 - date; A2 - narration (text); A3 - amount
B1 - blank; B2 - narration (text); B3 - blank
C1 -blank; C2 - narration (text); C3 - blank
now i want
A1 - date; A2 - combined text of A2,B2&C2; A3 - amount
after converting the three records into a single one, i don't need row
B & C.
this is required simply because to reduce the records and make th
worksheet size to 1/3.
can anyone help me?
-via13