Find and replace multiple statements simultaneously?

  • Thread starter Thread starter LizzyD
  • Start date Start date
L

LizzyD

hello!

Just wondering, is there an easy way to find and replace severa
statements at once?

eg. I have a spreadsheet full of information on hotels. One colum
lists the airport code of the nearest airport to each hotel. However,
would like to change all the codes to the actual airport names. So, fo
example, i want "LHR" to become "London Heathrow".

As my spreadsheet has around 3000 hotels and over 20 differen
airports, and I will also be receiving new spreadsheets showing th
airport codes instead of their names every week, I'd like do a Find
Replace on all the codes at once and then save this Find&Replace so
might use it again....

Does anyone have any idea how i might accomplish this? I hope I'v
explained myself properly! Would be very grateful for any ideas, or i
anyone could point me to a tutorial. Thanks very much!

Lizzy
 
ctlr+F. This will bring up the find box.click the replace
button. enter what you want to replace and what you want
it replaced with. click the replace all button.
 
It might be easier to create a data list of 2 columns, where the first one
holds the "code", and the other holds the full name. This list could be
placed in an out of the way section of the WB, say Y1 to Z20.

Then you could insert a column right after the "code" column in the main
area of the sheet and use a lookup formula to display the full name.

For example, if the "code" column of the main section was Column E, you
could enter this in Column F:

=VLOOKUP(E1,$Y$1:$Z$20,2,0)
And drag down to copy as needed.

You could then hide column E if you wish.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



hello!

Just wondering, is there an easy way to find and replace several
statements at once?

eg. I have a spreadsheet full of information on hotels. One column
lists the airport code of the nearest airport to each hotel. However, i
would like to change all the codes to the actual airport names. So, for
example, i want "LHR" to become "London Heathrow".

As my spreadsheet has around 3000 hotels and over 20 different
airports, and I will also be receiving new spreadsheets showing the
airport codes instead of their names every week, I'd like do a Find &
Replace on all the codes at once and then save this Find&Replace so I
might use it again....

Does anyone have any idea how i might accomplish this? I hope I've
explained myself properly! Would be very grateful for any ideas, or if
anyone could point me to a tutorial. Thanks very much!

LizzyD
 
Back
Top