Excel formula help needed......

[Countcussy]

I have data in a column of cells in the following format...

3SV19T022M
3SV19F022M
3SV19R022M
3SV19N022M

What I need is a formula to return me a value, depending on the letter it finds in a cell.

If it finds T, I want it to return OV
If it finds F, i want it to return FL
If it finds R, i want it to return SPLIT
If it finds N, i want it to return 316

Using the IF command, I can get it to return 2 of the values, but I can`t figure out how to get more.

Help would be greatly appreicated.

 

[Countcussy]

You sir are a GENIUS !!

Thank you. Just saved hours of manual adjustments !!

Whilst you are on the ball, there will be some cells that have the "T" in twice. I was thinking that i could alter the formula to just look for N,F & R, and have a default value return if it finds nothing. This would solve the "T" problem, as there would never be a combo.

Is that possible?

Thanks again.

 

[Countcussy]

The string is actually a pump manufacturers stock code. Each letter/number corresponds to an option. Generally speaking, there are 4 versions of each pump. All identical in terms of performance, but with differing port & material confugurations. Single and three phase versions also. I can decipher the number no problem, but we have some new staff starting, and I wanted to make it a little easier to understand, and import back into Sage

So now

3SV19T022M = 3SV19T022M - 240v - Oval Flange
3SV19F022M = 3SV19F022M - 240v - Round Flange
3SV19R022M = 3SV19R022M - 240v - Round/Offset Ports
3SV19N022M = 3SV19N022M - 240v - Round/316 SS

There are approx 400 pumps in the range, each with varying options. The amount of time this has saved me does not bear thinking about. I was only trying to help the new guys !!!!

Formula in place and working perfectly.

Thank you.