Good Morning- Can I delete the last text line in all 5000 cells

[tryin2makeit2]

Hello,
Thank you for reading my forum post.
I have a excel doc with 5000 item descriptions. Each of the 5000 cell's has a text paragraph in it. All of these cells are in 1 column with 5000 rows. I need to delete the last text line of every cell in this whole doc.

Thank you for your help.

Have a nice day.

Rob

[swatsp0p]

Rob: Please don't multi-post. See the answer by Ron in this thread: http://www.excelforum.com/showthread.php?t=369224

Multiposting is a no-no!

Thanks for understanding.