E
E
EVGENIJ NEFEDOV2018-03-03 23:39:34
excel
EVGENIJ NEFEDOV, 2018-03-03 23:39:34

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

1 answer(s)
J
John Smith, 2018-03-04
@nefedovgeka

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 question

Ask a Question

731 491 924 answers to any question