How to put space in between each Character in same cell with formula
Hi,
Am Thu, 8 Dec 2016 05:47:45 -0800 (PST) schrieb Sunil V:
Can you suggest me any basic formula for this ???
a formula is very long and not really readable:
=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A1,2,1," "&MID(A1,2,1)),4,1," "&MID(A1,3,1)),6,1," "&MID(A1,4,1)),8,1," "&MID(A1,5,1)),10,1," "&MID(A1,6,1))
Regards
Claus B.
--
Windows10
Office 2016
|