Hi all,

I need to split the numbers from the text in a list of cells, to be in two columns

i.e. 'mark 2341' to split out to 'mark' in one colum and '2341' in the other.

does anyone know a quick formula?

many thanks,

Nicko