Hi all,

I've got a long list of banks and building societies that are identified by a unique ID number (called a TU Number). If the building is a bank it will always begin with a TU1 number, if it is a building society it'll begin with TU8. I've put together a simple IF and concatenated formula to identify what type of building each is, but for some reason Excel always returns a "Building Society" value, even when the TU is definitely a bank ID. For instance the value in A4 is TU118220714, but still I get "Building Society". Here's the formula:

=IF(A4="TU1"&"*","Bank","Building Society")

Any ideas?

TIA,

SamuelT