I have a very very large spreadsheet which has a column formatted as follows: B 101.1.1. I need to delete the B and leave the numeric. How can I do this without deleting the B row by row?


You will need to split the one column into two columns and then you can delete the first one containing the letters.

Make sure the column to the right of your data is blank. If it is not, insert a new column by right-clicking on the column heading to the right and selecting Insert.

  1. Select the column with data by clicking its lettered column heading.
  2. From the Data menu, click Text to Columns...
  3. Within the conversion wizard, select Delimited. Click Next.
  4. Since there is a space between the letter and the numbers in your data, select Space as one of the delimiters. Click Next.
  5. Click Finish.
  6. Now you can delete the column with letters by right-clicking its column heading and selecting Delete.

Tags: excel

Last update:
2007-08-07 07:46
Author:
Ask MIStupid
Revision:
1.0
Average rating: 2.33 (3 Votes)

You cannot comment on this entry

Chuck Norris has counted to infinity. Twice.