How To

Formulas

On this page we'll take a closer look at the most common Excel formulas we use to transform inventory data.

 

Concatenate


The Concatenate function allows you to merge values from multiple cells into a single cell. This is beneficial if you have 2 columns of data that you would like to bring together with a 'separator'.

Example:

Note how the function is merging cell A1 with a "space" and cell B1. The "space" needs to be surrounded by double quotes.

 

Length


The Length (Len) function will count the number of characters from a cell and return the value. Helpful if you want to count your 'Auction Title' column length to make sure it will conform to the marketplace’s limit.

Example:

If you have a lot of titles, you can then use the Auto Filter described below to filter for only those titles that exceed the character limit to easily isolate and shorten them. Your Title Length formula will update as soon as you tab out of the Title cell.

 

Clean


The Clean function removes all non-printable characters from a string. This will help you remove unnecessary 'carriage returns' or other non-printable characters that may display improperly after Bulk Uploading / Updating.

Example:

 

Merge data from two columns to one


Similar to Concatenate. Take data from 2 columns and merge them together into one cell. You can also use a separator in between the merged data.

To use a separator, surround it with quotes, then again with ampersands.

On this page we'll take a closer look at the most common Excel formulas we use to transform inventory data.

 

Concatenate


The Concatenate function allows you to merge values from multiple cells into a single cell. This is beneficial if you have 2 columns of data that you would like to bring together with a 'separator'.

Example:

Note how the function is merging cell A1 with a "space" and cell B1. The "space" needs to be surrounded by double quotes.

 

Length


The Length (Len) function will count the number of characters from a cell and return the value. Helpful if you want to count your 'Auction Title' column length to make sure it will conform to the marketplace’s limit.

Example:

If you have a lot of titles, you can then use the Auto Filter described below to filter for only those titles that exceed the character limit to easily isolate and shorten them. Your Title Length formula will update as soon as you tab out of the Title cell.

 

Clean


The Clean function removes all non-printable characters from a string. This will help you remove unnecessary 'carriage returns' or other non-printable characters that may display improperly after Bulk Uploading / Updating.

Example:

 

Merge data from two columns to one


Similar to Concatenate. Take data from 2 columns and merge them together into one cell. You can also use a separator in between the merged data.

To use a separator, surround it with quotes, then again with ampersands.

0
Your rating: None
0
Your rating: None