How do I split a single cell into separate rows copied down? My delimiter is “.”
For example: in one single cell I have the text:
There are times when okay does not feel right. You need to stand firm. Let it go. Be very strong. And, when you least expect it, everything will work out. Say hello to a new day.
I need the text cell split into separate down row cells using the delimiter "period" with the space removed text alignment Left . Like this:
There are times when okay does not feel right.
You need to stand firm.
Let it go.
Be very strong.
And, when you least expect it, everything will work out.
Say hello to a new day.
Can someone write me a macro or function?? I’m new to Excel.
Thanks, Nick nick2010@hotmail.com
Bookmarks