I have 2 words I each cell, I would to put the 2nd word in a new cell, how am I doing it?
R Roger May 12, 2006 #1 I have 2 words I each cell, I would to put the 2nd word in a new cell, how am I doing it?
P Peo Sjoblom May 12, 2006 #2 Space delimited? Data>text to columns>delimited next, space as delimiter and finish make sure that the column to the right is empty before doing this -- Regards, Peo Sjoblom http://nwexcelsolutions.com
Space delimited? Data>text to columns>delimited next, space as delimiter and finish make sure that the column to the right is empty before doing this -- Regards, Peo Sjoblom http://nwexcelsolutions.com
