Answer the question
In order to leave comments, you need to log in
How to replace x-english with x-russian in excel or other text editor?
There is a column with text, headings: box 80x50, tray 100x50 and the like, you need to unify the goods and make x-Russian as a size separator, just find and replace it will not work because the text is full of just letters x, you need a replacement with the condition: if with on both sides of the numbers, then we change to Russian x.
Tell me how to do it.
Answer the question
In order to leave comments, you need to log in
In Word, this is done like this:
- the search with wildcards is included
- it is hammered into the search ([0-9])x([0-9]) , where x is Latin x
- it is hammered into the replacement \1х\2 , where x - XE Russian
Read like this: replace the found "(number from zero to nine) x in Latin (number from zero to nine)" with "(number from zero to nine, which was found before x)he Russian (number from zero to nine, what was after x)"
In Excel, this will not work, the simplest thing is to do it through word.
If you do it not in Word, in principle it will not be very difficult to do it through VBA, but you need to write a macro.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question