I have the text A012 This is a Test, can i use a custom format to display in
a cell just A012, the format of the text will always be letter followed by 3
numbers but i don't want any more letters.

I am sure this is simple but my heads not working today