Excel Quick Tips for SmartHQ Uploads
Updated
Print

Excel Quick Tips

Creating Usernames

For SmartHQ, when you want to upload users in masse for an upcoming market or for a new wave of employees at the market.

As an example:

Usernames that will be using their first initial and last name.

=CONCATENATE(LEFT(A12,1),B12)

This combines two Excel functions, Concatenate and Left. Concatenate combines cells together and Left allows you to take data from a cell to the left of the cell you are inputting the data into, you could also use the Right function for the same purpose.

 

Checking For Duplicates

Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values

Checking for duplicates allows you to see if someone created multiple accounts and adjust the accounts accordingly.

Example.

mceclip0.png

 

Checking for Special Characters

Our systems don't allow special characters to be uploaded, so it is best to remove them prior to upload. The usual special characters that we observe are: space, single quote, ampersand, comma and Asterisk.

You can check for special characters throw the use of the Find and Replace function. Hold Control then click F and this will bring up the function. Select “Replace” and go throughout the above special character to assist with uploading your documents.

 

Removing Spaces in UserName, FirstName, LastName Fields

SmartHQ will not upload user information if there are spaces in the UserName, FirstName or LastName fields.  This can be easily remedied by doing the following:

Click on “Find & Select” and choose Replace:

mceclip0.png

In the Find and Replace box, type a space in the “Find what:” field, and leave the “Replace with:” completely empty, then click Replace All:.

mceclip1.png

This will remove any spaces between valid characters.

Attachments
Excel Quick Tips.pdf
- 90 KB