madhuchelliah
Board Regular
- Joined
- Nov 22, 2017
- Messages
- 226
- Office Version
- 2019
- Platform
- Windows
Hey Guys. I need a macro to extract contents before 1st space i.e 1st word, likewise 2nd space i.e 2nd word and contents after the last space i.e last word of the cell. My source data is in I column from I2 cell and so on. Now macros should extract 1st word to C2, 2ndword to D2 cell and the last word which is after the last space should be in H2 cell. Please help Thank you.