Reading the last line in an Excel cell

Hello All,

I am working on an automation and i have a question that seems to be easy but i could not figure out how to do it.

I have a table that has one cell with multiple lines and i need to extract only the last line. this cell changes everyday and the number of lines is not constant.


I am using StudioX

Hi @firas try with


Thank you for your prompt reply.

i tried it as below but it did not work; what is wrong in my work?

in what to write field just write


thank you again…

now i am getting this message

Could you send me the workflow…?

Here we go (191.8 KB) (62.4 KB)

Here I am using regex because of your sentences are in single cell. not in rows.


Thank you so much…this is what i wanted but how can i include even the first part of the line that shows the time?

20:00: Work was done

now it is only saving: Work was done

Okay try this: (62.4 KB)

1 Like


thank you so much

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.