Hi!
Hoping ysomeone can assist me with something.
I have a file with multiple rows of text strings. I need to be able to identify which cells include punctuation that are not followed by a blank ("") or space (" ") - i.e. if followed by another character.
There are only 4 punctuation marks I'm worried about: comma (,), period (.), exclamation mark (!), question mark (?)
I've tried for over a day now and can't seem to find a solution.
Below is an example of 6 text strings (the 1st, 5th, and 6th rows fit the description outlined above):
asdfjhskhdfjwwww! Aaa,a
asdfasdfsf. Aaaa, a.
wellaaaa, asdfasdf, w.
asdfasdf. Asdfasdf, asas,
isnvojfdsn.oijbve ,oksh
jbvs, poihvokds?j
thank you!
![]()
Bookmarks