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
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