Converting special characters - How to convert special characters into Polish le

Question

I am converting dbf database to excel. By the way, it turns Polish letters into special characters. How to convert them back to Polish letters in Excel? Only uppercase letters are used.
How to convert special characters into Polish letters: ? = Ł, ?= Ę, ? = Ż, ? = Ą, ? = Ć, Ó = Ń, ? = Ó, ? = ź
I am not a programmer, I use excel, word as an intermediate.

PRL · Accepted Answer

Write a function in VBA for example. Code: VBScriptLog in, to see the code

PRL · Accepted Answer

Finished Feature: Code: VBScriptLog in, to see the code

Anonymous · Answer

There should be a find and replace function in these programs. You insert the character to search for and the character to be replaced with. After confirming the operation, the given character will be replaced with a new character. Unfortunately, I do not have these programs at hand. There is such a function in LibreOffice, so it probably is also in MS Office.

ta_tar · Answer

You can as follows (if you already know all the characters). You run "Find and replace" there you enter the first character, eg ?, and in the second field Ł. With find> replace you play in the exchange.
I can see that I checked for too long - I have already been warned.

Kresowianin · Answer

I know that, but it takes too long. I was thinking of some faster way - with one click ...

wojtek1234321 · Answer

In Word and Excel there is also an option Replace all (I mean it was, mine is old because Office 2007, maybe now new is not). Well, however, such a substitution can be applied to individual characters, so you would have to enter each character separately and then Replace all and so in turn for all characters ...

Kresowianin · Answer

[/ quote] In Word and Excel there is also an option "Replace all" (I mean it was, mine is "old" because Office 2007, maybe now "new" is not there). Well, however, such a substitution can be applied to individual characters, so you would have to enter each character separately and then "Replace all" and so in turn for all characters ...
That's not the point either

This is how you know, so I do. But my point is to be able to enter "swap all pairs" once and then give "swap all". I don't know if any macro? But I don't accept special characters ...

chojinka · Answer

You have an active Scandinavian keyboard, in the lower right year you click on the keyboard or badge like pl, etc., add a Polish keyboard and remove others, check the language in the main settings. There it can be assigned some other, you add Polish when it is not there and change it to the main one. you delete others. Then you enter exela languages, check what you have there, add Polish and create others ...

Kresowianin · Answer

PRL - you are closest to solving the topic. But there is one problem. At least for me - it doesn't accept the signs: ?, ?, ?, ?, Ó, Ó, ?, ?, ?. She puts a ? Sign everywhere. Added after 6 [minutes]: Polish keyboard, W10 system.

ta_tar · Answer

How do you enter these characters? Use insert symbol and select Latin-1 (complement) in the subset. Your stamps are there.

adamas_nt · Answer

The VBA editor will not accept any characters other than those in the table according to the locale. Check through AscW what code they have and proper basis.

Kresowianin · Answer

But where?

Kresowianin · Answer

PRL - thanks for your help. After compiling all the information, something like this came out that might help others if they had this problem:

Log in, to see the code

Added after 2 [minutes]:

The People's Republic of Poland led us to a solution.

[Solved] Converting special characters - How to convert special characters into Polish le

Post #1

Post #2

Post #3

Post #4

Post #5

Post #6

Post #7

Post #8

Post #9

Post #10

Post #11

Post #12

Post #13

Post #14

Topic summary