Thanks for the reply!

Some of the time it will be IFR 123456 etc with the space but often in column U it will be IFR#541566 with the hashtag for a space.

The formula looks like it could be modified to work but currently just showing #VALUE!