D
D
des1roer2016-06-17 13:38:15
excel
des1roer, 2016-06-17 13:38:15

Excel to swap words in one cell?

There is a file with a column First
name Last name Patronymic It is
necessary to convert to the Orthodox full name (Last name First name Patronymic)

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
des1roer, 2016-06-19
@des1roer

http://ru.stackoverflow.com/questions/536037/excel...

E
Eugene, 2016-06-18
@yellowmew

if you need to fix this particular cell, learn VBA scripting.
The easiest way is to enable the regexp functionality in your file (google excel regular expressions) and use it.
If you need to highlight the correct spelling in another column - use the functions.
examples are well analyzed from the source

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question