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.

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.

But that will put them in separate columns, Chandra wants them in separate
rows.
CLR wrote:
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.