Thread: Picking figures out of a cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Vince Vince is offline
external usenet poster
  
Posts: 22
Default Picking figures out of a cell

Gary''s Student wrote:
If the final set of digits is always a three digit number, then:
=RIGHT(A1,3)*1
if not, then use Text to Columns

--
Gary's Student

Thumbs up! Thanks

Reply With QuoteReply With Quote