Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
I have a list of urls in column B I need to remove everything after AND INCLUDING the ? and then delete any duplicates In column B.
Q) How can I do this with Vba Text to Column?
The list in Column B will be dynamic. All the urls will have a question mark in them however they will all be of different lengths.
Currently I have to use text to Column, I want to do this quickly with VBA
Currently everything after the ? goes into Column C, column C is then cleared I have to then delete duplicates in column B, leaving only unique records
Q) How can I do this with Vba Text to Column?
The list in Column B will be dynamic. All the urls will have a question mark in them however they will all be of different lengths.
Currently I have to use text to Column, I want to do this quickly with VBA
Currently everything after the ? goes into Column C, column C is then cleared I have to then delete duplicates in column B, leaving only unique records