View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chandra
 
Posts: n/a
Default 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.