Open Office Calc - remove numbers from cell, leaving text

Remove all numbers (runs of one or more digits):

1) Select the cells you want to change
2) Edit > Find & Replace
Search for: \d+
Replace with: empty
Options/Current selection only: ON
Options/Regular expressions: ON

Click Replace All

Remove numbers at the start:

1) Select the cells you want to change
2) Edit > Find & Replace
Search for: ^\d+\s*
Replace with: empty
Options/Current selection only: ON
Options/Regular expressions: ON

Click Replace All

Share on Google Plus

About Prof. Krishan Kant Lavania

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.