More explanation but you could probably use the RIGHT function to help
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Vikkib" wrote in message
...
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