How do I insert spaces between characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,

I have a column of data containing Initials and I want to insert a space
after each initial except the last one. Note that the number of initials
differ (e.g. some have 1, 2, 3 or 4 initials). What is the quickest way of
doing this?

Regards
 

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

Similar Threads

Text to Columns Question 3
Split column contents (de-concantenate) 7
Delimated Text 8
Limiting text entries 7
How do i insert blank rows between data that is thousands of rows 5
VBA - retrieve data on last create named range from previous inserted named range 0
Left, Right & If Function 2
Dynamic Chart Update Issue 7

Back
Top