Thread: Splitting text in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tieu Tieu is offline
external usenet poster
  
Posts: 4
Default Splitting text in a cell
See if this can help.
Assume your A1 cell contains: SHEFFIELD UNITED:BLADES

use formula in B1
=LEFT(A1,FIND(":",A1)-1)

use this formula in C1
=RIGHT(A1,LEN(A1) - FIND(":",A1))









Reply With QuoteReply With Quote