Tag: excel

Split data into multiple Excel worksheets based on column with VBA code

Rae Allen,

07/07/2016

I regularly get a block of data with 45 different entries in the first collum,…

Spreadsheet formulas: Prepend by concatenation

Rae Allen,

29/06/201629/06/2016

Have had to delve into some formulas for processing text files so needed someplace to…

Spreadsheet formulas: Remove characters from the right

Rae Allen,

26/03/201429/06/2016

Have had to delve into some formulas for processing text files so needed someplace to…