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.