Copying Highlighted "Space Only" In Exc

Closed

tochak - 14 Jan 2010 à 02:50
tochak - 14 Jan 2010 à 13:41

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

Réponse 1 / 2

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

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

Réponse 2 / 2

tochak
14 Jan 2010 à 13:41

Thanks Venkat,

It worked!