=IF(LEFT(B2,2)="UG","yes","No")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"gingerbread" wrote in message
...
|
| Im trying to clean up data in my worksheet in Column B there is Location
| Numbers that start with eg UG, UG-100 etc my following IF statement only
| gives me a Yes for the Rows with UG only but I want the UG-100 to come
| up with a Yes to and a No for any other data which shouldn't be in that
| column
|
|
| =IF(B2="UG","yes","No")
|
|
| --
| gingerbread
| ------------------------------------------------------------------------
| gingerbread's Profile: http://www.excelforum.com/member.php...o&userid=37233
| View this thread: http://www.excelforum.com/showthread...hreadid=569414
|