Harry0
Member
Within a single cell has multiple lines within which I want to extract a row, ex: 3rd row.
At first I thought of using =find("^P", a1, 1) But that did not work. ^P meaning paragraph since it works in search/replace. Each cell is completely different.
Cell can say
random sentence 1
random sentence 2
random sentence 3
random sentence 4
random sentence 5
Again all within 1 cell. So how does one get what is highlighted in bold?
Thanks
At first I thought of using =find("^P", a1, 1) But that did not work. ^P meaning paragraph since it works in search/replace. Each cell is completely different.
Cell can say
random sentence 1
random sentence 2
random sentence 3
random sentence 4
random sentence 5
Again all within 1 cell. So how does one get what is highlighted in bold?
Thanks