DELET PERTICULER WORD FROM THE EXCEL SHEET

  • Thread starter Thread starter Amit
  • Start date Start date
A

Amit

I WANT TO KNOW THAT HOW CAN I DELET ONE SINGLE WORD WHICH IS MENTIONED IN
DIFFRENT DIFFRENT CELL BY CLIKING ONE TIME OR BY SOME FORMULA....PLEAS LET ME
KNOW.
 
Have you tried find and replace:

Put the word you want to delete in find and leave it blank the replace option.

regards
rajesh
 
Amit said:
I WANT TO KNOW THAT HOW CAN I DELET ONE SINGLE WORD WHICH IS MENTIONED IN
DIFFRENT DIFFRENT CELL BY CLIKING ONE TIME OR BY SOME FORMULA....PLEAS LET ME
KNOW.
Click to expand...
=====================================================

DO ONE THING ,SUPPOSE A1 CELL CONTAIN NAME " VINAY KAMALE " AND YOU WANT
TO REMOVE " KAMALE" FROM THIS NAME ,THEN PUT "KAMALE" IN CELL B1 THEN ADD
THIS FORMULA IN CELL C1 =REPLACE(A1,SEARCH(B1,A1),LEN(B1),"")

REGARDS

HARSHAWARDHAN S SHASTRI

INDIA

=====================================================
 
Back
Top