Thread: Splitting the contents of a cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default Splitting the contents of a cell?
Dan,
try the following formula, which assumes that your text is in A1.
MID(A1, FIND(":", A1)+1, LEN(A1)

HTH
Kostis Vezerides

Reply With QuoteReply With Quote