More Excel Tips

Extract First Name From A Cell

 

combine two cell values use of concatenate function

 

Extract Last Name from A Cell Value

 

CONCATENATE MULTIPLE VALUES IN ONE CELL