I have a Spreadsheet (LibreOffice) file which includes a Column with Full Names.
I need to extract each name, create an Email address from it and insert it into a another column on the same row.
Email Addresses needs to be created in the form of: NAME.SURNAME@domain.com.
The Name column Includes names such as “Name Surname”
As an Example, if the Name column includes John Doe, I would like LinreOffice Calc to automatically insert John.Doe@domain.com in another Column in the same row.
Is it possible to create a Macro which will automatically parse and insert an Email address from the Name Column?