View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default How can I pick up characters after the first 4 in Excel cell

=RIGHT(A1,LEN(A1)-4)

"KKay" wrote:

I have a cell containing digits and alpha numeric characters. I want to pick
up just the alpha numeric characters which are all after the first four
characters in the cell.

Is there formula I can use without having to split out the first 4
characters with the formula LEFT...