I have a problem with some text strings I recieve. They have a tab before the last initial of a name and I can't figure out how to get rid of it without losing the last letter. The text looks like this when pasted into the text box, but I see a "square" in excel signifying a tab. Does anyone know how to remove this without going through each one individually? I tried using Data, Text to Columns, Delimited without sucess. The tab delimiter causes the last letter to not show up. The only other way I can think of solving this issue is to pull the last letter then add it again after the tab delimited function. Any suggestions would be appreciated.
Example.
"JOHN, DOE
J"
Example.
"JOHN, DOE
J"