Thread: How do you remove some numbers in a series eg 1500024500 = 24500
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default How do you remove some numbers in a series eg 1500024500 = 24500
Hi

If they are always the same length then
=RIGHT(A1,5)
This will return a Text value. If you want it as a numeric value then
=--RIGHT(A1,5)

--
Regards

Roger Govier


"BobDylanfreak" wrote in
message ...
Please help


Reply With QuoteReply With Quote