Friday, November 26

SOME EXCEL FORMULAS


Split Forename and Surname

 

 

 

 

 

 

 

                 

 

 

The following formula are useful when you have one cell containing text which needs

   

 

 

to be split up.

           

 

 

One of the most common examples of this is when a persons Forename and Surname

   

 

 

are entered in full into a cell.

           

 

                 

 

 

The formula use various text functions to accomplish the task.

     

 

 

Each of the techniques uses the space between the names to identify where to split.

   

 

                 

 

 

Finding the First Name

 

 

 

 

 

 

 

                 

 

   

Full Name

First Name

         

 

   

Alan Jones

Alan

 =LEFT(C14,FIND(" ",C14,1))

   

 

   

Bob Smith

Bob

 =LEFT(C15,FIND(" ",C15,1))

   

 

   

Carol Williams

Carol

 =LEFT(C16,FIND(" ",C16,1))

   

 

                 

 

                 

 

 

Finding the Last Name

 

 

 

 

 

...

[Message clipped]  



--
Thanks & Regards,
Anshul Mandowara


Speak your mind