Updating First and Last Name Columns

When you have a spreadsheet that contains a first name and a last name, how can that be mapped to the “Name” field or “Contact Name” field within Blitz Lead Manager?  The solution is to create a new field (ex. Full Name) within your spreadsheet before you try the upload.

For example, if you have the spreadsheet and column A “first name” and column B is “last name”, here is how you would proceed:

• Open spreadsheet
• You can insert a new column “C” and call it “Full Name”
• Go to the C2 cell and enter this exact formula: =CONCATENATE(A2,” “,B2)
• Copy the formula (cell C2) down under column “C” (all rows).
• Save the file

Now you can continue with the import process and use the Full Name column to map to the Lead Name or Contact Name within Blitz Lead Manager.