Hi,

I have a cell which contains "49423011June14"

I would like a formula which just extracts the first number up to an occurance of a letter e.g. 49423011

Can anyone help please?

Paul