View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ant1983 ant1983 is offline
external usenet poster
 
Posts: 12
Default find and replace

I'm sure this can be done so pls assist...

I have to worksheets.

The first one has two columns: Old Label and New Label.

The 2nd worksheet has several columns and i want to do a search in a
specific column (column O). The search should be the text in the other sheet
(Old Label) and all matches should be replaced with the New Label.

Please help!