Excel, how to enter space between initials in name column 1

[johnbarr44]

I have been asked to correct a spreadsheet listing thousands of surnames and initials in two columns, with further columns containing data for each person.

The 'initials' column contains either one, two or three upper case initials. The initials have no spaces between them, but these are required.
Is there an easy way to create a space between the initials?

Data as presented:
A
AB
ABC

Format required
A
A B
A B C

Thanks for any suggestions.
John B

 

[strongm]

I don't know an easy way of doing it through spreadsheet function, but the following user defined function should do the trick:

[blue]Public Function Spacer(strSource As String) As String
    Spacer = Trim$(Join$(Split(StrConv(strSource, vbUnicode), ChrW$(0)), " "))
End Function[/blue]

 

[johnbarr44]

Many Thanks strongm. That did the trick and saved me a heap of work.