Copying Highlighted "Space Only" In Exc

Question

[Closed]

Report

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 replies

Ask a question

venkat1926 · Answer 1 · 2010-01-14T05:52:03-0500

Answer 1 / 2

venkat1926

800
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

tochak · Answer 2 · 2010-01-14T13:41:20-0500

Answer 2 / 2

tochak
Jan 14, 2010 at 01:41 PM

Thanks Venkat,

It worked!