how do i delete some information from different cells at time

[Guest]

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

 

[Guest]

You could use Find and Replace - the replace value would be blank
HTH
Sheila

 

[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

 

[Guest]

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.