View Single Post
  #1   Report Post  
Old August 11th 21, 07:56 PM
velvick25 velvick25 is offline
Junior Member
 
First recorded activity by ExcelBanter: Aug 2021
Location: USA
Posts: 1
Default Insert Space Between Initials

Hello -

I have an export file that I need to format the name cell in order to import it into another software. Is there a formula that can split the initials in a name? Names have all different lengths for first and last name.

Current Cell:
John MDoe

Needs to be:
John M Doe

Thanks

Last edited by velvick25 : August 11th 21 at 07:58 PM