Hi Guys,

Its really different all the other posts

i want to create a macro for reducnmg teh cell values length.

for example
A B c
1 y LLU123456 -
2 j LLU345678 -
3 m LLU987456 -
4 s LLU456123 -

As per teh above..

If teh cell A contains "Y" and "J" teh Value of C should be 8 digits value.(ie.. Should reduce a digit of B and pated here(LU12345).

If the cell A contains M and S teh value of C should be 6 digits value.(ie..should reduce the 3 didgit from teh B value and pasted.. (1978456))

Can someon ehelpw me here sort thsi out ?? :'(

My cry for your help.

Per day i will have to correct 300 cells:'( My cry for your help..!!

Many thanks in advance.
Safi.