Text Calculation

[George TOUBALIS]

I recieved an excel file with names

The man who wrote the names put the last name first then a comma and then the first name.

I want a calculation to make the name with this order

First name & Space & last name

Can you help with this problem???

[aaa]

Create calculated field

Your_name=(RightWords(name,1)&" "&LeftWords(name,1)

[George TOUBALIS]

It do not work so well...

see the file please...

Artist_BMG_Converted.fp7.zip

[Breezer]

you need a calculation to check if there's a comma. If no comma, leave name as is. If there's a comma, then perform the calculation. Change your calculation to:

Case (

comma = 0;Name;

(RightWords(Name;1)&" "&LeftWords(Name;1))

)

That's it.