How do I insert spaces between characters
 

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

How do I insert spaces between characters
 

=TRIM(LEFT(A1)&" "&MID(A1,2,1)&" "&MID(A1,3,1)&" "&MID(A1,4,1))
--
David Biddulph

"mayoyo" wrote in message
...
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