if it is always in that format then
=value(left(cell,2))
will work but I presume that the number of digits can change. If there is always a space after the 1st number then
=value(left(cell,find(" ",cell)-1))
should work for you
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244