How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,831
- Office Version
- 2010
- Platform
- Windows
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...
Excel Workbook | |||
---|---|---|---|
A | |||
6 | HT | ||
7 | HTT | ||
Sheet1 |