New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

find and replace text

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

find and replace text

Postby gopa_12 » Tue Jun 07, 2016 7:00 am

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
  • 0

gopa_12
Rookie
 
Posts: 1
Joined: Jun 7, 2016
Reputation: 0
Excel Version: 2013

Re: find and replace text

Postby gebobs » Tue Jun 14, 2016 8:35 am

=B1 and copy down?
  • 0

gebobs
Regular
 
Posts: 74
Joined: Feb 23, 2015
Reputation: 9
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 78 guests

cron