I need your help, guys!
Is there any way to find only specific data and replace it with blank in programming? See below for example:
Before - I am searching for AA
AA BBCCAA
ABBAACC
AABBCC
After - the result should be the following:
BBCC
ABBCC
BBCC
Your help on this is appreciated.
You can use the built in Find/Replace features.
Go to Edit|Replace
Find What: AA
Replace With: (leave blank).
Click Replace All. Click Ok.
To eliminate leading spaces..
Go to Edit|Replace again
Find What: (enter a single space)
Replace With: (leave blank).
Click Replace All. Click Ok.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks NVBC!
I require a vba code but it is fine! I have found in MSDN a sample code that replace a specific data.
ActiveSheet.Columns("A").Replace What:="AA", Replacement:="", _
SearchOrder:=xlByColumns, MatchCase:=True
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks