Thread: data splitting
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Phil Hibbs Phil Hibbs is offline
external usenet poster
 
Posts: 100
Default data splitting

....or if you don't want to specify the arbitrary length limit, you
could do it this way:

=RIGHT(A1,LEN(A1)-FIND(",",A1))

Phil Hibbs.