Copying Highlighted "Space Only" In Exc

Closed

tochak - Jan 14, 2010 at 02:50 AM
tochak - Jan 14, 2010 at 01:41 PM

Hello,

I have a row of numbers in a single cell. What is the best way to split these in their individual cell?

Thanks.

2 responses

Answer 1 / 2

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 14, 2010 at 05:52 AM

what is the logic of separation (space, comma or any other puncuation)
then use data(menu bar)-text to columns

Answer 2 / 2

tochak
Jan 14, 2010 at 01:41 PM

Thanks Venkat,

It worked!