Insert space between each charcter

[JohnExcel222]

INSERT A SPACE INTO A TEXT VALUE
Hi there,
I would like to add a space between each charcter, using a formula ( no VBA ).
A1: TREE
B1: T R E E

Thanks

 

[Rick Rothstein]

enough check here: Excel functions (alphabetical)

THANKS! I like this webpage as it shows the Excel version that new functions were added.

 

[sandy666]

THANKS! I like this webpage as it shows the Excel version that new functions were added.

You are welcome

They changed layout and info about usage function(s) for more useless (in the past it was much better) but good it is still exist

 

[jtakw]

I've seem a number of "function lists" like this from various sources, but so far, I haven't seen one that doesn't have it's shortcomings.

This one, 1 example for instance, the TEXTJOIN function shows "2016", but in fact, a 365 subscription is required, whereas, the SEQUENCE function, shows correctly as "365".

 

[sandy666]

TEXTJOIN function
Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2019 for Mac

 

[TonyUK72]

If you place a space in cell C1, you can then paste this formula into cell B1

=CONCATENATE(IF(LEN(A1)>=1,LEFT(A1,1),""),C1,IF(LEN(A1)>=2,MID(A1,2,1),""),C1,IF(LEN(A1)>=3,MID(A1,3,1),""),C1,IF(LEN(A1)>=4,MID(A1,4,1),""))

You would of course need to amend the formula to account for the longest word you have in your list.