Good Morning Everyone,
Hope you all are staying healthy!
In Column A I have approximately 100 rows of text string. Around 25 of them look like this(PK 280 0109045 000-099)while the remainder look like this(098 0792545 000-019). What I need to do
is delete the "PK" portion of the strings with a macro. Unfortunately I can't use LEN -2 because it would remove the first 2 characters from the rest in the range.
Any help would be appreciated!
Thanks,
D
No need for VBA. Just use this:
=IFERROR(SUBSTITUTE(A1,"PK ",""),A1)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks Ali. The problem with that is the data is every changing and in different rows. If I can insert that formula to run in a macro on range A:A that should work.
Maybe this helps.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Bakerman2,
That is the ticket! Thanks a bunch!
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks