I'm sorry, i'm relatively new to excel, i'm not sure what you mean by
"recorder" or how to use it. It seems a little complicated. Is there not an
easier way, such as "find and replace" or something ?
Thanks
Andrew
"Gary's Student" wrote in message
...
Andy100:
Paul Sheppard's good suggestion can be automated if you have a number or
substitutions that have to be repeated periodically. Just by using the
Recorder
Consider attacking: "Now is the time for all good men to come to the aid
of
their party."
Sub Macro1()
Selection.Replace What:="now", Replacement:="won", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="is", Replacement:="si", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="the", Replacement:="eht", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="for", Replacement:="rof", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Your substitutions should be just as easy using the Macro Recorder.
Good Luck
--
Gary's Student
"Paul Sheppard" wrote:
Andy100 Wrote:
How do i get excel to replace words from data imported from the net.
Here is the problem. I am using excel to fetch data from a flight
timetable,
however, when it says "KL" for the flight number, i want it to correct
itself to "KLM". Also, when it says "BA", i want it to correct itself
to
"BAW".
i.e. "KL7746" would automatically change to "KLM7746".
Thanks in advance !
Regards
Andrew
Hi Andrew
Try highlighting the column with the flight codes then do Edit
Replace
In find what type KL and in replace with type KLM
etc....................
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread:
http://www.excelforum.com/showthread...hreadid=399812