Our list of most used and most common Excel formulas required at FMG.   Remove everything before the first comma =RIGHT(B5,LEN(B5)-FIND(“,”,B5)) Remove everything after the first comma =LEFT(B5,FIND(“,”,B5)-1)