Hello, if one cell in Excel has a paragraph that only the middle text changes.
Example: (The cell is A1) and it has the following text
The following users are listed in this group :
David Smith
Thomas Smith
Henry Smith
Jennifer Smith
Published Date: 2015-05-25
Blah blah blah
End of example:
How can I tell the cell above to just give me the names. It could start at the : and end at Published.
I'd like to be able to grab the names and if possible put them in their own cells.
The idea behind this is, I will have multiple cells all with this type of paragraph so for each cell I'd like it to just retrieve the names only.
Can this be done?
Final goal:
A1 is the original paragraph
A2 is David Smith
A3 is Thomas Smith
A4 is Henry Smith
A5 Jennifer Smith
Help?
Bookmarks