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

[TABLE="width: 237"]
<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>[TR]
[TD="class: xl63, width: 29, bgcolor: transparent"] [/TD]
[TD="class: xl64, width: 94, bgcolor: #D9D9D9"]A[/TD]
[TD="class: xl64, width: 64, bgcolor: #D9D9D9"]B[/TD]
[TD="class: xl64, width: 64, bgcolor: #D9D9D9"]C[/TD]
[TD="class: xl64, width: 64, bgcolor: #D9D9D9"]D[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]1[/TD]
[TD="class: xl63, bgcolor: transparent"]AGP17.24 − L7[/TD]
[TD="class: xl63, bgcolor: transparent"]AGP17.24[/TD]
[TD="class: xl63, bgcolor: transparent"]L17[/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]2[/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]3[/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]4[/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]5[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]6[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]7[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[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)