I don't know how to do that by formatting the cell but you can extract those numbers into a spare cell using a formula like
=IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=1,TRIM(A1),MID(A1,1,LEN(A1)-FIND(" ",A1)))+0
This thread is now locked and can not be replied to.
The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch
1995-2015: How technology has changed the world in 20 years
How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona
The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.