Thread: removing a letter to the beginning of each part number of a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] joeu2004@hotmail.com is offline
external usenet poster
  
Posts: 418
Default removing a letter to the beginning of each part number of a co
"vcff" wrote:
I need to remove the letter at the beginning of each part number.

=right(A1,len(A1)-1)

That results in text. If you want a number, then:

=value(right(...))
Reply With QuoteReply With Quote