View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 594
Default how do I extract the last three digits from each cell in column?

=RIGHT(A1,3) and copy down

Vaya con Dios,
Chuck, CABGx3


"PeggyT" wrote in message
...
I am using excel 2007. Each cell in a column contain varied length of data
but ends with "Program ###". I would like to extract ### into an adjacent
column for all cells in the first column.
Thanks!
PeggyT