Basic ? - How to return a single character to the left of the target

[Ed_B]

My first post here with thanks in advance for any help.

I want to return only the number to the left of - which is separated by a space. This is the desired result:

Luna Quartz Level 3 - Pool	3
Supreme Matrix Level 1 - Spa	1

<tbody>
</tbody>

When I use the formula =LEFT(A2,(FIND("-",A2)-1)), all values to the left of - are returned instead of just the 3 and 1.

Thanks again.

 

[jtakw]

Hi,

Try this, it'll work for single or double digits:

Book1
	A	B
1	Luna Quartz Level 3 - Pool	3
2	Supreme Matrix Level 1 - Spa	1
Sheet13

Cell Formulas
Range	Formula
B1	=TRIM(MID(A1,FIND(" -",A1)-2,2))+0

 

[Ed_B]

Works fine Thank you

 

[jtakw]

You're welcome, welcome to the forum.