Separate Firstname Lastname in Excel

The first column/first row(A1) has the name for example Sourav Bhattacharya.

For the firstname B1 should have the formula like 

=LEFT(A2,(FIND(" ",A2)))

For the last name in C1 the formula should be like

=RIGHT(A2,(LEN(A2)-(FIND(" ",A2))))

Install Exchange Server 2010 on Windows Server 2008 R2

Install server 2008 R2,Install DNS and DC

Go to the exchange directory in command prompt

setup /PrepareAD /OrganizationName:Sourav

setup /PrepareALLDomains

Install 2007 Office System Converter: Microsoft Filter Pack.

Open Powershell with administrative credential 

Type import-module ServerManager

Add-WindowsFeature NET-Framework,RSAT-ADDS,Web-Server,Web-Basic-Auth,Web-Windows-Auth,Web-Metabase,Web-Net-Ext,Web-Lgcy-Mgmt-Console,WAS-Process-Model,RSAT-Web-Server,Web-ISAPI-Ext,Web-Digest-Auth,Web-Dyn-Compression,NET-HTTP-Activation,RPC-Over-HTTP-Proxy,Desktop-Experience -Restart.

Then Run the command on powershell

Set-Service NetTcpPortSharing -StartupType Automatic

Now Start Exchange from setup file in GUI

Exchange 2010 Hub Transport Role Installation Fails error solved

Open Registry Editor.

Locate the registry subkey:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip6\Parameters

In the details pane, click New, and then click DWORD Value.

Type DisabledComponents, and then press ENTER.

Double-click DisabledComponents, and then type 0xffffffff in Hexadecimal or 4294967295 in Decimal.

Restart

Run the exchange setup again