Topic: | Re:Re:Re:Re:Excel - removing words at start of cell - replace can't do it | |
Posted by: | John Ridout | |
Date/Time: | 18/03/15 18:35:00 |
You can regain the original order of rows after a sort and deleting the required rows/words as follows: Insert new column to the left Enter 1 in the top cell Select all cells in the column for which there is data in the next column Edit Fill Series Linear Growth value 1 Sort oncolumn 2 and delete unwanted rows/data etc Sort again on column to return to original row order Delete column 1 |