taurean
Well-known Member
- Joined
- Jun 17, 2011
- Messages
- 2,190
- Office Version
- 365
- 2016
- Platform
- Windows
Also there is famous Hiker's list on MrExcel which I remembered later.this is insanely close to what i was referring to thank you. just wish it was organized in categories, but beggars cant be choosers.

Splitting Single Column Data Into Three
Hi All! I am having data in a single column ..nearly 10,000 cells.. column A 1 FLOWERS ROSE JASMIN TULIP 2 DOGS BULLDOG GERMANSHEPHERED I Would like to split this data AS Column A Column B Column C 1 FLOWERS ROSE 1 FLOWERS JASMIN 1...
@mikerickson As I understood this post is for helper for quick search and not for end users per se. I might be wrong!