Advertisements I use TEXTSPLIT to cut text composed of multiple parts, like for example: the country, the date and the value: "USA-01/01/2023-1000" =TEXTSPLIT(A1,"-") Unfortunately, the result is a spill formula (dynamic array) where the date and the value are "text" (which is normal after a text function). This poses a big problem if I want… Read More How to apply number or date format to columns after TEXTSPLIT in Excel

Advertisements conditional format right side multiple columns(green highlight) based on what is data put on left side multiple columns hi all i want to format right side i.e. green filled cells if the data matched what is on left side columns. every time i have to choose "equal to" conditional format for cell individually I… Read More How to conditional format RANGE of cells based on multiple multiple columns?