Forum Discussion
Solved
Clean cell for unwanted and dynamic part
Hi, I have a datasheet with a lot of numbers and in each celle there is af number and a number with in a (). Does anyone know of a clever way to clean all the numbers in the () togehter with the ...
=LEFT(A1,FIND(" ",A1)-1)
this will give you everything up to the first " " (space). If there isn't always a space you can swap it for =SUBSTITUTE(LEFT(A1,FIND("(",A1)-1)," ","")
Which will give you everything up to the first ( and then remove any blank spaces which will stop you accidently getting text back rather than numbers.
=LEFT(A1,FIND(" ",A1)-1)
this will give you everything up to the first " " (space). If there isn't always a space you can swap it for =SUBSTITUTE(LEFT(A1,FIND("(",A1)-1)," ","")
Which will give you everything up to the first ( and then remove any blank spaces which will stop you accidently getting text back rather than numbers.
Thank you :)