Thread: =left or =right
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Rook[_2_] The Rook[_2_] is offline
external usenet poster
  
Posts: 70
Default =left or =right
I have column A populated with numbers which all end in a letter for example
123A, 1258M, 999Z. In the B i woul like to the numbers excluding the letter,
ie 123, 1258, 999.

How do I do this?
Reply With QuoteReply With Quote