Reports, your help please...

[ct1bxx]

Hello Jordi,

Many thanks for your help.

In fact yesterday I have read the help (Shazam Power Query) for this purpose but not found the solution I need.

The fomat works fine, however it is not the solution I am looking for, I only need one (4digit) QTHLocator. 

If I have a qth Locators like :
JO21BD
JO21PC
JO21RJ
JO21WT

I want only one JO21 and what I got is 4 - JO21 while I only want one JO21 the first or the last no matter. I have tried to use Show First but I got error.

Sorry to take your time.
Have a nice week.
73 Manuel Fernando ct1bxx