excel function

🎓 學業台教學

[匿名]

2007-09-16 3:05 am

is there any excel function that can delete unwanted words in cells? thanks

回答 (4)

Ivanism

2007-09-18 7:08 pm

✔ 最佳答案

Replace function can satisfy your need. For example,

abcde in A1
abcef in B1
abecf in C1

Now you want to take out the word "c", go to Edit -> Replace, type c in "find what" and empty in "replace with". Then press replace all. Then all c in the words will be delete.

👍 0 👎 0

joe

2007-09-16 11:18 pm

use the FIND and REPLACE function, and choose the REPLACE ALL option.

👍 0 👎 0

Clement

2007-09-16 5:23 pm

Click on the cell and you'll see the content at the top.
Just select the part that you want to delete by dragging and press bksp/delete.

👍 0 👎 0