Excel Data: Extract Last2Chars

Usuario

extract the last two characters from the weather column using a regex function

AutoGsheet Wizard

I'll proceed with adding the REGEXEXTRACT formula to each cell in a new column to extract the last two characters from the "Weather" column. After that, I'll provide you with a link to download the modified file. Let's start this process.

The data includes a "Weather" column, and you would like to extract the last two characters from this column using a regular expression function. To achieve this in Google Sheets, we can use the `REGEXEXTRACT` function. Since I'll be modifying the Excel file directly using `xlsxwriter`, I'll apply this formula to the relevant column in the Excel file. I'll proceed with adding the `REGEXEXTRACT` formula to each cell in a new column to extract the last two characters from the "Weather" column. After that, I'll provide you with a link to download the modified file. Let's start this process.

AutoGsheet Wizard

The Excel file has been successfully modified to include the REGEXEXTRACT formula for extracting the last two characters from the "Weather" column. You can download the modified file using the link below:

Download the modified Excel file

The Excel file has been successfully modified to include the `REGEXEXTRACT` formula for extracting the last two characters from the "Weather" column. You can download the modified file using the link below: [Download the modified Excel file](sandbox:/mnt/data/dummy_sales_data_with_regex.xlsx)