kmprice710
Board Regular
- Joined
- Jan 8, 2014
- Messages
- 87
- Office Version
- 2019
- Platform
- Windows
I have Office Professional Plus 2019.
How do I fix this?
I have a column of cells with phrases like
"Adams, a went to the bathroom"
"Smith, d. lifted weights"
"Jones, maxwell ate dinner"
"The store would not serve Williams, t.j."
The shoe did not fit Thompson, f."
"Stuart, d and Pyle, Gerhard did not like Velma, uly"
The info is presented as "Last name, first name" or "Last name, first initial" or "Last name, first initial with a period" or "Last Name, first two initials" or "Last Name, first two initials with periods" with the first name or first initial in lower case.
The name can appear at the beginning, in the middle or at the end of the cell.
I want to change the cells to:
"A Adams went to the bathroom"
"D. Smith lifted weights"
"Maxwell Jones ate dinner"
"The store would not serve T.J. Williams"
"The shoe did not fit F. Thompson"
"D Stuart and Gerhard Pyle did not like Uly Velma"
I don't need end-of-sentence punctuation.
How do I do it?
How do I fix this?
I have a column of cells with phrases like
"Adams, a went to the bathroom"
"Smith, d. lifted weights"
"Jones, maxwell ate dinner"
"The store would not serve Williams, t.j."
The shoe did not fit Thompson, f."
"Stuart, d and Pyle, Gerhard did not like Velma, uly"
The info is presented as "Last name, first name" or "Last name, first initial" or "Last name, first initial with a period" or "Last Name, first two initials" or "Last Name, first two initials with periods" with the first name or first initial in lower case.
The name can appear at the beginning, in the middle or at the end of the cell.
I want to change the cells to:
"A Adams went to the bathroom"
"D. Smith lifted weights"
"Maxwell Jones ate dinner"
"The store would not serve T.J. Williams"
"The shoe did not fit F. Thompson"
"D Stuart and Gerhard Pyle did not like Uly Velma"
I don't need end-of-sentence punctuation.
How do I do it?