software

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 gt; TextToColumns gt; Delimited gt; Next gt; choose both Space and the Other
boxes and type a period in the Other window.

Vaya con Dios,
Chuck, CABGx3

quot;chandraquot; wrote:

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

But that will put them in separate columns, Chandra wants them in separate
rows.
CLR wrote:
gt; Data gt; TextToColumns gt; Delimited gt; Next gt; choose both Space and the
gt; Other boxes and type a period in the Other window.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt; quot;chandraquot; wrote:
gt;
gt;gt; Task 1.2
gt;gt; Task 11.2
gt;gt;
gt;gt; These are the data which appear one below the other in different
gt;gt; rows, I am finding it difficult to have the data converted only to
gt;gt; get the 1 and 11s in a separate row using text to columns as text to
gt;gt; columns. Are there any ways out to do it in Excel.