Tip Printed from ExcelTip.com
Add space between characters and numbers in Microsoft Excel
data in cell A1: A100 Formula in cell B1: =LEFT(A1,1)&" "&RIGHT(A1,LEN(A1)-1) Result: A 100