If function and text does not work

[GeorgeKerstholt]

Office 365 Pro Plus on Windows 7 professional 64 bit
(see attachement)
I have 4 columns
Column A contains 2 cells with individual names: Mary, Pete,
Column B contains a score: P2P, P3P
column C contains a score: P2U,P3P,P4P,M2U,M3M

I use the IF function toe separate the scores in column D & E.

Column D: IF(B1="P2P";"P";"u") if column B contains the value P2P write P otherwise write U. The outcome however is U.
Column E: IF(B1="P3P";"p";"u") if column B contains the value P3P write P otherwise write U.The outcome however again is U

Same goes with the columns trying to separate on column C

Values are separated by a comma, putting a space after the comma makes no difference. As there are several hundred scores a solution is sought for.

[jayajaya_4]

hey dear ur description is not matching ur file...pls give a bit more clarifications u need??

[Jonmo1]

hey dear ur description is not matching ur file...pls give a bit more clarifications u need??

Not to mention it's a duplicate post.
http://www.excelforum.com/excel-form...-not-work.html

[FDibbins]

HI, welcome to the forum

1st, I think you forgot to upload your file?

2nd, if you have P2P, P3P in a single cell, then you need either use a different approach (see below) or use the entire contents in the IF. Your IF is looking to find ONLY P2P, but the cells does not contain only that.

Here is 1 method that will give you what you want...
=IF(ISERROR(SEARCH("P2P",A1,1)),"U","P")

However, if the "2" keeps changing, you will need to change that manually. If you are ONLY looking for P-a number-P, then this will work better for you...
=IF(ISERROR(SEARCH("P?P",A1,1)),"U","P")

[FDibbins]

Thanks Jonmo

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.
http://www.excelforum.com/excel-form...-not-work.html