I have a column of several cells, each with text/numbers. How can I automatically create a list containing the first line of each cell?
I have a column of several cells, each with text/numbers. How can I automatically create a list containing the first line of each cell?
How are the 'lines' delimited?
On second reading, your post is still a little unclear
=LEFT(A1, FIND(CHAR(10), A1) - 1)
Returns the text up to the first para char but you may mean something else by 'list' - like everything in 1 cell.
Thanks very much, that's fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks