Hello all,
My apology in advance if this is the wrong board to ask.
I have a text file with about 2,000 lines of following data, e.g.
==============================================================
Mary was born on 2/13/70 and she was attending the Greenwood elementary school.
John was born on 11/4/56 and she was attending the Eastside elementary school.
==============================================================
I need to be able to copy the "date" in the sentence to the beginning of the sentence and add a blank space after the "date".
So, each line will look like:
=====================================================================
2/13/70 (space) Mary was born on 2/13/70 and she was attending the Greenwood elementary school.
11/4/56 (space) John was born on 11/4/56 and she was attending the Eastside elementary school.
=====================================================================
How do I create the macro to achieve this result? I appreciate all your helps!
My apology in advance if this is the wrong board to ask.
I have a text file with about 2,000 lines of following data, e.g.
==============================================================
Mary was born on 2/13/70 and she was attending the Greenwood elementary school.
John was born on 11/4/56 and she was attending the Eastside elementary school.
==============================================================
I need to be able to copy the "date" in the sentence to the beginning of the sentence and add a blank space after the "date".
So, each line will look like:
=====================================================================
2/13/70 (space) Mary was born on 2/13/70 and she was attending the Greenwood elementary school.
11/4/56 (space) John was born on 11/4/56 and she was attending the Eastside elementary school.
=====================================================================
How do I create the macro to achieve this result? I appreciate all your helps!