Feb 04 2022 06:12 AM
Bonjour!
J'ai eu un problème à l'issue de la conversion d'un fichier PDF en Excel, je me suis retrouvé avec des colonnes séparées par des points à la place des virgules. Et je n'arrive pas à utiliser
Feb 04 2022 09:10 PM
@Max-Lumu How did you perform the conversion? And if the column separator consistently is a decimal point, try using Text-to-columns, delimited by a point.
Otherwise, perhaps Power query can help.
Feb 07 2022 01:21 AM
Feb 07 2022 02:08 AM
@Max-LumuNo guarantees that PQ will work, but in the link below you find some more information.
https://docs.microsoft.com/en-us/power-query/connectors/pdf
From my own experience I can tell that the quality of the import highly depends on origin of the file.