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:

[TABLE="width: 240"]
<tbody>[TR]
[TD]Luna Quartz Level 3 - Pool[/TD]
[TD="align: right"] 3[/TD]
[/TR]
[TR]
[TD]Supreme Matrix Level 1 - Spa[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

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.