Name reformatting

[JanaZ]

Hi There

Could you please help me find the best way to reformat the name?

Name	New Name
Zhang Jana	Zhang,Jana
Zhang Sheng Jana	Zhang Sheng,Jana

[flying008]

Hi, @JanaZ 

Just for you:

ReverseString(ReplaceFirst(ReverseString(Trim([Name]))," ", ","))

******

If it can help you , please mark it as a solution and give a like for more share.

[grazitti_sapna]

@JanaZ , Here are 2 other ways to achive your results using regex and GetWord functions: