View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dominic
 
Posts: n/a
Default how do I copy text to columns from one cell to another?

Stressed,

You successfuly converted one row already, correct?

You should be able to select multiple rows and peform the same operation.
This will do what you did to row one, to each of the rows that are
highlighted.

Did you used "Fixed Width" or "Delimited" for your first row?

"Stressed!" wrote:

its not lettin me do that, can u be more specific?

"jim" wrote:

You should be able to highlight column A and repeat the Data Text to
Columns action. This will apply the change to every row in that column.