Trim formula

I didn't realize that you wanted all 3 sections if there are 2 colons

With
G5: (the text to parse....eg AVM:Pioneer Clinic:Dave McAfee)

This formula returns the part after the LAST colon

J5: =MID(G5,FIND(CHAR(8),SUBSTITUTE(G5,":",CHAR(8),
LEN(G5)-LEN(SUBSTITUTE(G5,":",""))))+1,255)

This formula returns the AVM part....only if there are 2 colons
otherwise it is blank ("")

H5: =IF(LEN(G5)-LEN(SUBSTITUTE(G5,":",""))=2,LEFT(G5,FIND(":",G5)-1),"")

This formula returns the section BEFORE the last colon
(EDITED to correct a formula error)

I5: =MID(SUBSTITUTE(G5,":"&J5,""),LEN(H5)+1+(LEN(H5)>0),255)

In the above example, these values are returned:
AVM
Pioneer Clinic
Dave McAfee

Does that help?