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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top