Insertina a space between numbers in a column

  • Thread starter Thread starter Diego
  • Start date Start date
D

Diego

How would I change all of the values in a column from
"xyzxyz" to "x y z x y z". I can change each row in the
column manualy but I would like to know if there were a way
to do this for the entire column all at once.

Thanks for the assistance!
 
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F8,MID(F8,1,1),MID(F8,1,1)&"
"),MID(F8,2,1),MID(F8,2,1)&" "),MID(F8,3,1),MID(F8,3,1)&" ",1)

and copy down. It depends on the repeating pattern abcabc (and not
abcdef) as your illustration indicated.

Alan Beban
 
Without investigating, I would guess there is a limit on the number of
SUBSTITUTE's that can be nested, like the limit of 7 nested IF statements.

Alan Beban
 
Back
Top