View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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