Skip to main content

how to separate first name, middle name and last name in excel

Simple way to separate FULL NAME to FIRST name, MIDDLE name and LAST name in excel with find, left and id function presented by 99Excel.Com (Akumar)

First Name :        =IFERROR(LEFT(A2,FIND(” “,A2)-1),A2)

Middle Name : =IFERROR(MID(A2,FIND(” “,A2)+1,(FIND(” “,A2,FIND(” “,A2)+1)-FIND(” “,A2)-1)),””)

Last Name :        =IFERROR(IFERROR(MID(A2,FIND(” “,A2,FIND(” “,A2)+1)+1,100),MID(A2,FIND(” “,A2)+1,100)),””)

how to separate first name, middle name and last name in excel



Urgent requirements for 10 male Fresher candidates, + Excel knowledge must.

Urgent requirements for 10 male Fresher candidates, + Excel knowledge must.


Location : Noida Sector 63


Company: Orient craft ltd





Reference: 99Excel.Com (Ninety Nine Excel Training Academy)



Please ask to all student those are looking for jobs to send their resume at given ID.



Regards, Ajit

Excel Job opportunities

The candidates shall have following skills :-

  • Good working knowledge of MS Excel & Word
  • Good Knowledge of MS Power Point
  • Competent in internet operation.
  • Competent in reading and writing English.
  • Operational knowledge of Tally/Busy will be a plus point.
  • Educational qualification :- Preferably BCOM/BBA. BA/BSc candidates may also apply if the have skills as specified above.

Working responsibilities are as follows :-

  • Preparing invoices, quotations, reports, etc.
  • Coordinating with customers for seeking feedback of Engineers performance, report submission, invoice submission, feedback on quotation submitted, etc.
  • Maintaining proper record and ensuring documents are kept in respective files to maintain traceability of documents.
  • Coordinating with Engineers for assigning duties and keeping record of their visits
  • Checking TA/DA bills of Engineers after they return from their respective sites after completion of job.
  • Checking bills received from vendors and entering in systems.

We will pay Rs. 8,000.00 PM for up to 3 months (training period). After 3 months, salary will be increased to Rs. 9,200.00 PM. After 1 year, if the performance is good then we may raise the salary up to Rs. 11,500.00 PM. After that up to 10% salary hike per year based on performance.

We have to hire the candidates so that they join us from 01/01/2017 onwards.


Call: Arun Pawar, Quality Head , Mob.:- 09891174696, 09810059715

Mail: Send you resume at:


Team – 99EXCEL.COM





Create individual pdf from mail merge

Create individual pdf using mail merge in word from Excel

Copy + Paste below code in word file and Press F5


Sub Create_PDF_From_Mail_Merge()
‘This vba code written by Akumar –

Application.ScreenUpdating = False
Dim DocName As String, PDFPath, Folderpath, From, Till, Message, fs
Folderpath = “C:\ – Folder”

Set fs = CreateObject(“Scripting.FileSystemObject”)
If fs.FolderExists(Folderpath) = False Then
fs.createfolder (Folderpath)
Else: End If

From = 1
Till = 5

Message = (Till – From) + 1
While From <= Till

ActiveDocument.MailMerge.DataSource.ActiveRecord = From
DocName = ActiveDocument.Fields(4).Result
PDFPath = Folderpath & “\” & DocName & “.pdf”
Massage = ((Till – From) + 1)

ActiveDocument.ExportAsFixedFormat OutputFileName:=PDFPath, ExportFormat:= _
wdExportFormatPDF, OpenAfterExport:=False, OptimizeFor:=wdExportOptimizeForPrint, Range:=wdExportAllDocument, _
Item:=wdExportDocumentContent, IncludeDocProps:=True

From = From + 1

MsgBox (Message & ” Pdf Files Saved In = ” & Folderpath)

End Sub