How can I identify columns in my Excel sheet that contain more than 200 characters?

Modified on Wed, 6 Jul, 2022 at 4:20 PM

Labregister provides the option to insert Short Text (200 characters) and Long Text (16.000 characters) Attributes. By just looking at your existing inventory sheets, it can be difficult to estimate which would be the best option for you here. When using too many characters, this can occur in an error message while using Labregister.

To check the character length in your Excel file, please follow the steps below:

  1. In the list of Items to import, use an additional column to check the character count.
  2. Apply the formula =LEN to this additional column to count the length of text in a cell.
  3. By double-clicking on the cross icon at the bottom of the cell, you can extend the formula toward the end of your list.
  4. Navigate to Data > Filter to enable a filter for each of the selected columns.
  5. In your column to check the length, select all the values larger than 200.
  6. You can choose between correcting the length of a cell in your Excel file or using the type Long Text in Labregister.

Tip: If all the above is too much of an ordeal, you may just as well opt for the LONG TEXT attribute. However, this may deplete your quota sooner.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article