how do i delete some information from different cells at time

M

maddy

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
 
S

SamuelT

Just do a 'Replace' (Ctr+H) and in the 'Find What' field put 'annua
income' and in the 'Replace With' field, leave it blank.

Think that'll do it.

Samuel
 
M

Miguel Zapico

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.
 
Top