Excel Hi, I want to add or remove spaces between initials in an Excel 2007 spreadsheet

Joined
Oct 6, 2015
Messages
1
Reaction score
0
I have names in two formats e.g. L J J Company and LJJ Company, I'd like them all to have the same format, preferably L J J i.e. letter,space,letter, but if it's easier to remove all spaces that's fine.

I've tried 'find and replace' using ([A-Z].)([A-Z].) and /1 /2 or ([A-Z])([A-Z]) and /1 /2 but neither work or the other way round

Thanks in anticipation :-)
 
Back
Top