Data TextToColumns Delimited Next choose both Space and the Other
boxes and type a period in the Other window.

Vaya con Dios,
Chuck, CABGx3

"chandra" wrote:

Task 1.2
Task 11.2

These are the data which appear one below the other in different rows, I am
finding it difficult to have the data converted only to get the 1 and 11s in
a separate row using text to columns as text to columns. Are there any ways
out to do it in Excel.