Trim, Mid...?

[orbea_adam]

Hi Guys, I have data formatted as "General" that looks like the following:

5144 / 22 - Both - LWRV

510 / 8 - Both - DO

5377 / 4 - Annual - LWRV

101 / 25 - Both - DO

How should I get rid of the spaces and keep just the numbers and " / "? I can think of trim, mid, left, right, but the number of characters will always vary as in the example.
Thanks
Adam

 

[Seti]

Here's one way, assuming that there is a dash as shown:

=LEFT(SUBSTITUTE(A1," ",""),FIND("-",SUBSTITUTE(A1," ",""))-1)

It gets rid of all spaces, finds the dash and uses that in the left function.

 

[orbea_adam]

Here's one way, assuming that there is a dash as shown:

=LEFT(SUBSTITUTE(A1," ",""),FIND("-",SUBSTITUTE(A1," ",""))-1)

It gets rid of all spaces, finds the dash and uses that in the left function.

Thank you

 

[barry houdini]

I imagine you only need one SUBSTITUTE....

=SUBSTITUTE(LEFT(A1,FIND("-",A1&"-")-1)," ","")

 

[orbea_adam]

I imagine you only need one SUBSTITUTE....

=SUBSTITUTE(LEFT(A1,FIND("-",A1&"-")-1)," ","")

Barry,
Thank you for the solution, but can you explain how it works, please?
Adam