Hi
I have one cell which contains many lines of text (not formulas) describing something. I want to have another cell that gives a shorter description and extract only say the first five lines of this text. Is it possible?
thanks
Hi
I have one cell which contains many lines of text (not formulas) describing something. I want to have another cell that gives a shorter description and extract only say the first five lines of this text. Is it possible?
thanks
What separates the lines of text? Is it a full stop / a new line / something else?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Separated by full stop.
Use:
Formula:Please Login or Register to view this content.
Change cell reference A1 as required. Change the number 5 to change the number of lines returned.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks