Glad to help. Have a look at help indes for REPLACE and/or SUBSTITUTE

--
Don Guillett
SalesAid Software

"yefei" wrote in message
oups.com...
thsnak very much
another issue
how to get rid of part of the text in a cell?
for example, if a cell contains "welcome", then i remoce it, and copy
the rest content of the cell to somewhere else.