RE: how do i delete some information from different cells at time

Giganews Newsgroups
Subject: RE: how do i delete some information from different cells at time
Posted by:  Miguel Zapico
Date: Tue, 23 May 2006

You can do it with the menu option Edit->Replace, type "revenue accuracy" in
the "Find what" field, and leave "replace with" blank.  You can repeat for
"annual income"
If you want to do it with formulas, you can use something like:
=SUBSTITUTE(A1,"revenue accuracy","")

Hope this helps,
Miguel.

"maddy" wrote:

> samuel12.123.1456.125 revenue accuracy
> samuel12.123.1456.125 revenue accura
> samuel12.123.1456.1revenue accuracy
> samuel12.16.1revenue accuracy
> sa12.123.1456.125annual income
> samuel3.1456.125annual income
> samuel12.123.1456.125  annual income
>  how do i delete revenue accuracy and annual income without disturbing other
> data in the cell

Replies

None

In response to

how do i delete some information from different cells at time posted by maddy on Tue, 23 May 2006