Please see the attached sample.
We have a column A with a big cell that has a lot of line breaks in it and we want to extract 2 pieces of data from it.
How do we do it with formulas?
Please see the attached sample.
We have a column A with a big cell that has a lot of line breaks in it and we want to extract 2 pieces of data from it.
How do we do it with formulas?
Last edited by nicoan; 01-05-2022 at 09:46 PM.
based on samples, assuming XL2013, one option:
Formula:Please Login or Register to view this content.
Ah.. perfect..
Works like a charm.
Thanks a million!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks