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??

Perhaps try:

Please Login or Register  to view this content.

if you want the above to be valid mailing link use

Please Login or Register  to view this content.

Note: it is assumed you always have "forename surname" in A2 where not "blank" - if not you need to outline what should happen in those scenarios