madhuchelliah
Board Regular
- Joined
- Nov 22, 2017
- Messages
- 226
- Office Version
- 2019
- Platform
- Windows
Hello All, i have to delete a space based on condition in a string. I have the data in D column which is string type and range is dynamic. In all the cells in the column, if the second word(that is after first space in the string) is an alphabet (A to Z) then the space (that is first space in the string) before the alphabet has to be deleted. The alphabet will be always any single character from A to Z. it will be helpful if the output is in VBA. Thank you.