Microsoft Office Forums - View Single Post - [Solved] Help with Formula to extracting text from text string

Thread: [Solved] Help with Formula to extracting text from text string

View Single Post

Old

02-03-2018, 12:47 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

I might have used a sledge hammer...

D3 copied down to D5

=MID(C3,FIND("::",C3,1)+2,LEN(MID(C3,FIND("::",C3, 1)+2,LEN(C3)))-LEN(MID(C3,FIND("@",SUBSTITUTE(C3,":","@",4)),LEN( C3))))

Reply With Quote