Thread: [Solved] Excell Name formula
View Single Post
 
Old 10-28-2011, 07:45 AM
SheenLim SheenLim is offline Windows XP Office 2007
Novice
 
Join Date: Oct 2011
Posts: 2
SheenLim is on a distinguished road
Default Excell Name formula

What formula would I use if my first column have
"Calicdan, Prince Russell"
"Fabro, Aiza"

and on my second column I want it to display with a format like firstname.lastname. so result should look like these on the second column:
"prince.calicdan"
"fabro.aiza"
Reply With Quote