Try editreplace

What: L

With: nothing

Replace all.


Gord Dibben MS Excel MVP

On Thu, 2 Aug 2007 11:20:08 -0700, Office Lapis <Office
wrote:

I have been asked to give a total of all the Liters since 2006. In the excel
column there is a quantity using numbers but after the number is (L) for
liters. I wanted the total sum of about 2000 rows and cannot get it unless I
manually delete all the (L)'s from each cell individually. Is there a way
to take out all the (L)'s at the same time or am i going to have to do all
the 2000 entries separately.