User Profile
SandraJee
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Find Text in Cell that has multiple data
Hi, I have a data sheet that I download. The issue is that it's giving me a lot of different text/data in one cell, so I have to split it out into different cells in order to pivot and run reports on this data. I am using If(ISNUMBER(SEARCH formula to extract specific data into different cells, however, there is one particular cell where I have more than the 64 nested limit. Is anyone able to help? Many thanks to any who is able to assist.Solved932Views0likes2Comments
Recent Blog Articles
No content to show