Hello,
I have a spreadsheet that has city name in column C and a state name in Column D. The issue is that sometimes the city and state are included both in Column C. I have listed these states in column f
Is there a macro to find everything in column c that ends with everything in column f and removes these from column c?
Attached same excel file for reference.
So I want to remove MA and NY in C7 and C8
Thanks again for the help!!
Just use a formula
in G2
=IF(" "&RIGHT(C2,2)=" "&D2,LEFT(C2,LEN(C2)-3),C2)
and copy down the column
Now copy column G, then Paste Values over the top of column C
Delete column G
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Try below code:
PHP Code:Sub rpla()
Dim arr(), sArr, i
arr = Range("C2:" & [d65000].End(xlUp).Address)
For i = 1 To UBound(arr)
sArr = Right(arr(i, 1), 3)
If arr(i, 2) = Trim(sArr) Then _
arr(i, 1) = Replace(arr(i, 1), sArr, "")
Next i
Range("C2:" & [d65000].End(xlUp).Address) = arr
End Sub
Last edited by bebo021999; 08-08-2016 at 10:48 AM.
Quang PT
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thanks to all --- Mumps1 did the trick!!
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks