This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Good call- this works most of the time...until I come across a customer with a middle initial.
Example: John J Smith
It's transforming it to [John] [J Smith]
I tried to put in a second text to columns tool and that works - but only when there is a middle initial! A customer without a middle initial will return a NULL value after the 2nd text to columns tool.
Is there a way to use a formula tool to trim off the first character that is followed by a white space? Something like that might do the trick...