I'm trying to create a formula that takes a text string of unknown length and returns it after inserting a space between every character.
For example, if
A1="FOO" then the formula should return
"F O O".
I can successfully return my example above with the following formula, but it's long and is hard-coded for 3 character strings:
=MID(A1,1,1)& " "& MID(A1,2,1)& " "& MID(A1,3,1)
Is there a more compact method that works with strings of any length?