Collate company email list from names in a cell

[Johnagall]

I've searched around in concatenation etc but can't quite find the solution that is slicker that concatenating a few times.

I have a list of 500 names in a worksheet and I need to make a list of company email addresses.

The format is currently, cell A1 - firstname space surname in one cell and I need to modify to read firstname.surname@company.co.uk

Do I need to modify the single cell and have A1 =first name B2=surname first?

and then use =Concat(A1 ".", B2, "@company.co.uk")

Is there a single step way?

 

[Michael M]

Can you post a small sample of data.
Have a look at using XL2BB to upload your sample.
The link to XL2BB is in my tag.

 

[Michael M]

Try this and thenclick on the little black square in the bottom RH corner of the cell that holds the formula

=A1&  "." & B2 & "@company.co.uk"