How to reverse the first name and last name

Hello again,

I just tried, but it indeed doesn't work because there are sometimes two first names.
Example from my file:

Albert Bastien LASTNAME

So, it would be about finding a formula that would convert what is written in uppercase to lowercase, and if possible directly in a single cell...

It would result in
LASTNAME Albert Bastien

Thanks in advance!!!

SEARCH: We search for the position of the space character in cell A1 starting from character 1.
SEARCH (search string; cell to search; starting character for the search)
FOR EXAMPLE A1: DUPONT CHRISTIANE
SEARCH(" ";A1;1) => 7

LEFT (source string; n): extracts the first n characters: In our example, we see that we want the first 6 characters, so the result of search -1.

RIGHT(source string; n) extracts the last n characters. We need to determine n n = Length of the source string - the number of characters up to and including the space, that is
LEN(A1)-SEARCH(" ";A1;1)

We base it on the space, which is why the only concern will be composite names or first names...

For more precision:

RIGHT and LEFT functions
http://www.mdf-xlpages.com/modules/publisher/item.php?itemid=81

SEARCH and FIND functions
http://www.mdf-xlpages.com/modules/publisher/item.php?itemid=93

Hello,

Thank you for all your responses. What I did was the famous Right formula, etc... and if I found, for example:
Albert LASTNAME Antoine
I would cut and paste the name to place it in front...
Fortunately, there weren't too many.

In any case, thanks to everyone!

Hello,

I didn't find the property, but thanks anyway!!

Caro

Hello,
I hadn't received all the replies (not displayed on my phone).
But are you talking about the Excel file including first name last name, then last name, then first name, and finally the famous name and first name?
Indeed, I wanted to avoid creating new columns, knowing that the file I have was created differently (not all the columns are next to each other, and I don't have a good grasp of the software).
But I am still trying to understand its formula; what do the numbers like 999 etc. correspond to?

I have other files with the same issue, so I will apply its formula!

Thank you all!

Indeed, I wanted to avoid creating new columns, knowing that the file I have was created differently (not all the columns are next to each other, and I don't master the software)
Have you tried the macro proposed earlier? It doesn't require adding a column

Best regards.