Save time with the CONCATENATE and SPLIT functions in Spreadsheets
For years, I’ve been manually adding and splitting data. Oops. Until a few weeks ago, when I was pointed out that you can automate this with two handy EXCEL (or Spreadsheets) functions: Concatenate and Split. Concatenate First up, Concatenate. With the Concatenate function, you can bundle values from multiple cells. This is ideal, for example, […]