Thread: Too Much Data per cell, how to sort and find info per cell? =function?
View Single Post
  #2  
Old 06-23-2007, 04:12 AM
CaptainQuattro CaptainQuattro is offline
Forum Contributor
  
Join Date: 23 Mar 2006
Location: Vancouver
Posts: 116
CaptainQuattro is an unknown quantity at this point
functions find, mid
Try this formula:

=MID(B4,FIND("ssn:",B4,1)+6,9)