|
02-04-2018, 04:42 PM
|
|
Advanced Beginner
|
|
Join Date: Mar 2015
Posts: 79
|
|
Quote:
Originally Posted by jeffreybrown
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))))
|
Hi,
This works wonderfully!
Thank you,
|