I have costs in one column and different operatives in another and need to
extract the cost of each operative but the cells with the operative code in
also has the week number. I need a formula to just pick out the code. The
data in the cells looks like this: WP:W52:3 :BEV01 The code BEV01 denotes
the operative. Any ideas