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

=RIGHT(A1,3)

"PeggyT" wrote:

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