Edit email address

[elephant]

I have a data file that contain email however some of the data email is not completed and the email address is make up of the user last and first name. Can anyone advice how i can edit this email col data? Thank you

[alexnajm]

Can you give us some sample data and the expected result? We can't work with what you've explained so far - for example, how is the new email constructed? first.last@example.com?

[elephant]

okay. For example i had the following data. Can you also tell me if there any other way to calculate the yrs they been hire i am currently using a formulae like this  

i am currently using date time diff with date time today to do the calculation.

Is there another way?

[Qiu]

@elephant 
You want to complete the Email address or the Hire Year?

For Hire Year, I think your approach has no problem.

[elephant · Accepted solution]

I want complete email address. 

Thank thank then i would just use that for my hire date :)

[alexnajm · Accepted solution]

[Last Name] + ‘_’ + [First Name] + ‘@abc.com.sg’

[elephant]

Thanks for the help.