DELET PERTICULER WORD FROM THE EXCEL SHEET
 

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.

DELET PERTICULER WORD FROM THE EXCEL SHEET
 

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" wrote:

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.

DELET PERTICULER WORD FROM THE EXCEL SHEET
 

"Amit" wrote:

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.

================================================== ===

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

================================================== ===