Subash_G
New Member
- Joined
- Feb 9, 2025
- Messages
- 3
- Office Version
- Prefer Not To Say
- Platform
- Windows
Our requirement: I have 3 columns in my excel sheet. The 3rd column has data in multiple lines. Each line data in 3rd column cell has either in Green font color or in Black font color. I need to split these lines in 3rd column cell into rows. For example. if there are 3 lines in 3rd column cell, there should be 3 rows created 1 row per 1 line data while 1st 2 columns data should be same as the original data. Appreciate if you could look into this and share a solution on how to split lines in cell into rows without disturbing the format of the cell either by using VBA or any excel formula. |