Excel: Add Spaces


Hello, what formula could I use to add a space between letters please... =LEFT(F3,1)&" "&RIGHT(F3,LEN(F3)-1) is working for two letters but I can't work out what formula to use to get this working for 3 letters... Sheet1

 A
6HT
7HTT



This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of September 17, 2016.


For more resources for Microsoft Excel