Hiding #Value Error

Hello,

I am simply trying to hide the #value error but I am strugling a lot.

Column A, and Column B

The formula is

Cell B2.
=IF(A2="","",LEFT(A2,FIND(" ",A2)-1))&"."&RIGHT(A2,LEN(A2)-FIND(" ",A2))&"@microsoft.com"

No if a2 is blank, or even if it has a formula that is showing the cell value blank, I would like to keep the cell B2 blank. For some reason wherever in column A there is a blank cell in column B #Value is showed.

Any help please??