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

C

chandra

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.
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
P

Paul Lautman

But that will put them in separate columns, Chandra wants them in separate
rows.
 
Top