Most valuable professional
  • Hot Topics

Excel Change tab name - delete 3 characters

Hi I have a excel sheet with tabs named (short weekday in norwegian-date) like: M-1.1 T-2.1 O-3.1 To-4.1 F-5.1 etc to: To-31.12 Is there a easy way to remove the letters and the hyphen so result will be: 1.1 2.1 3.1 4.1 5.1

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of June 8, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel