In our project we have an app that provides data of coordinates with "N" and "E" for Lat and Lon correspondingly. We get the data as Excel and want to open it as shape in QGIS. We get a lot of small datasets from the app, so deleting the Ns and Es in the Excel file or otherwise change all the Excel files would be time-consuming.
Is there a way to import the coordinates as they are? With the "N"s and "E"s in the columns.