Thread
:
delete first 4 letters in a cell
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
delete first 4 letters in a cell
=RIGHT(A5,LEN(A5)-5)
or
=RIGHT(A5,LEN(A5)-FIND(" ",A5))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Wanna Learn" wrote in message
...
Hello I want to delete the first four characters in a cell example
MRS.
Mary Johnson I want to delete MRS. I tried "left, and mid function but I
must be doing something wrong. Thanks for your help
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett