cell data
 

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

cell data
 

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

cell data
 

I did try that but didn't really know what I was doing. I ended up with the
data W52: BEV01 in the cell.

What I have is a cost of labour on a contract. there are different
operatives on the contract and each operative has a code. Every week the
payroll produces a cost is put into the contract in one cell beside the
operative code and wk number in the other cell. This contract is virtually a
year long so each week the week number changes but I need to extract the cost
of each operative according to their code. For example
WP:W52:3 :BEV01 £38.88
WP:W19:3 :HAS01 £420.00
WP:W19:3 :BEV01 £1200
I need a total of the cost of BEV01



"Don Guillett" wrote:


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

cell data
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Vikkib" wrote in message
...
I did try that but didn't really know what I was doing. I ended up with
the
data W52: BEV01 in the cell.

What I have is a cost of labour on a contract. there are different
operatives on the contract and each operative has a code. Every week the
payroll produces a cost is put into the contract in one cell beside the
operative code and wk number in the other cell. This contract is
virtually a
year long so each week the week number changes but I need to extract the
cost
of each operative according to their code. For example
WP:W52:3 :BEV01 £38.88
WP:W19:3 :HAS01 £420.00
WP:W19:3 :BEV01 £1200
I need a total of the cost of BEV01



"Don Guillett" wrote:


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