Hi,
I have a column A which contains email ids of all our users. Basically I want to add two additional columns ( First and Last name) which can be retrieved from those email:
Current
<tbody>
</tbody>
Desired Output
<tbody>
</tbody>
Thanks in advance for your help
I have a column A which contains email ids of all our users. Basically I want to add two additional columns ( First and Last name) which can be retrieved from those email:
Current
Tel | Exchange | |
kate.nash@theice.com | +13230323032 | CBOT |
amar.prem@theice.com | +12324434344 | CBOT |
henry.graves@theice.com | +14323434434 | CBOT |
<tbody>
</tbody>
Desired Output
First Name | Last Name | Tel | Exchange | |
kate.nash@theice.com | Kate | Nash | +13230323032 | CBOT |
amar.prem@theice.com | Amar | Prem | +12324434344 | CBOT |
henry.graves@theice.com | Henry | Graves | +14323434434 | CBOT |
<tbody>
</tbody>
Thanks in advance for your help