Comments on: How to remove first (left) or last (right) characters in Excel

When working with unstructured text data, you often need to parse it to retrieve relevant information. This article will teach you a few simple ways to remove any number of characters from the left or right side of a text string. Continue reading →

Comments page 2. Total comments: 38

  1. Formula work with ; and not with , in Office 365

    1. Hi Hrvoje,

      That depends on the List separator set in your Windows Regional settings. In the USA, UK and some other English-speaking countries, it's a comma. In most European countries, the default list separator is a semicolon because a comma is used as the decimal point.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)