Insertina a space between numbers in a column

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!
 
A

Alan Beban

=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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make elements in a row space between instead of wrapping when choosing multiple columns 0
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1
X,Y,Z values to be extracted and posted respectively in excel 5
Excel VBA macro, search - accumulate - delete original 0
Section and Page numbering 0
Find match between cells and copy data 7
Excel does not accept text format! 0
Adding a big matrix in Word 2013 5

Top