convertTask 1.1, Task 11.1 which come one below the other into no
 

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.

convertTask 1.1, Task 11.1 which come one below the other into no
 

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.

convertTask 1.1, Task 11.1 which come one below the other into no
 

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.