LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 11th 21, 07:56 PM
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


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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert blank space Ed Peters Excel Programming 4 September 10th 07 12:55 AM
how can I insert a space every three characters? Sam Excel Programming 4 February 14th 07 07:25 PM
Insert Space sabegirl Excel Discussion (Misc queries) 2 May 28th 06 04:44 AM
Insert Tab Space dok112[_108_] Excel Programming 2 March 29th 06 01:36 AM
Macro to insert a space Lame Dame via Excel Programming 2 March 23rd 06 05:37 PM

All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017