Tag Archive: RIGHT

Articles sur le thème : RIGHT

Functions LEFT – RIGHT – MID

Text functions are convenient to extract a part of a cell. In the following examples, you will see in many examples how to extract a part of a cell LEFT function We want to extract the dialing code of cells. The dialing code is the first 3 digits of the phone number. To extract these figures, …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/left-right-mid/

Convert YYYYMMDD to DD/MM/YYYY

You can easily convert date YYYYMMDD to DD/MM/YYYY in Excel with the option Table to Column. All the explanation in this article

Permanent link to this article: https://www.excel-exercise.com/convert-date-yyyymmdd-to-dd-mm-yyyy-without-formula/