Excel Formatting Problem

  AndySD 17:22 11 Jan 11

I have an excel sheet that contains either one number or multiple numbers seperated by a space. All the numbers have a space after them,
e.g. 67(space) or 34(space)68(space)

What I need to know is there an easy way to format the cells so that only the first number is left without the space in each row.



  VoG II 17:40 11 Jan 11

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…