Trim formula query

[EvansB2]

Hi there,

I'm trying to split a list of alpha numeric location references as shown in cell A1 into two distinct references that I require, as shown in cells B1 & C1.

Can anyone assist?

Any help would be grateful and I can tell my team off for not collecting the data properly in the first place!

Regards

Ben

	A	B	C	D
1	AGP17.24 − L7	AGP17.24	L17
2
3
4
5
6
7

<colgroup><col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;"> <col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;"> <col width="64" style="width: 48pt;" span="3"> <tbody> </tbody>

 

[FormR]

Hi, shouldn't the C1 result be "L7"?

If so, one option might be..

Excel 2013/2016
	A	B	C
1	AGP17.24 - L7	AGP17.24	L7
Sheet1

Cell Formulas
Range	Formula
B1	=LEFT(A1,FIND("−",A1)-1)
C1	=MID(A1,FIND("−",A1)+1,255)