Thread: Excel 2002 : How to remove the digits from original reference ?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low Mr. Low is offline
external usenet poster
  
Posts: 505
Default Excel 2002 : How to remove the digits from original reference
Hello Dave,

Thank you for the formulas

It works well.

Kind Regards

Low




--
A36B58K641


"DaveO" wrote:

To remove the last three digits, assuming your "before" entry is in
cell A1:
=MID(A1,1,LEN(A1)-3)

To remove the first three digits, assuming your "before" entry is in
cell A2:
=MID(A2,4,LEN(A2))


Dave O


Reply With QuoteReply With Quote