i have a particular column A:A as :- another column B:B as :-
text1 t1
text2 t2
. .
. .
. .
textN tN
i wanted to replace every text in column A with text in B (replace text1 with t1 and so on...)
How can i do this using excel formulas .. Macros are the last resort as already the file is too heavy ..thanks