hey guys
how can i in a sheet find string "FAB002" and whenever i find it i should replace it with "125389_00" string.
thnks in advance
regards
hey guys
how can i in a sheet find string "FAB002" and whenever i find it i should replace it with "125389_00" string.
thnks in advance
regards
Find and Replace, Ctrl-H
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
i know this xld but i want to integate it in a macro u c ?
[VBA] Activesheet.Cells.Replace What:="FAB002", Replacement:="125389_00", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
[/VBA]
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Then do it in Excel with the macro recorder on. This will create the code and show you a technique.Originally Posted by mehdoush
Last edited by Bob Phillips; 07-05-2009 at 08:29 AM.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
thank you guys