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
I want complete email address.
Thank thank then i would just use that for my hire date
[Last Name] + ‘_’ + [First Name] + ‘@abc.com.sg’
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?
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?
@elephant You want to complete the Email address or the Hire Year?
For Hire Year, I think your approach has no problem.
Thanks for the help.
