Category Archives: code

Concatenate with Line Breaks in Apple Numbers

If you want to concatenate two elements in a Numbers spreadsheet and include a line break between them, use CHAR(8232) to represent the line break. For example, putting a line break between the contents of cell A1 and B1 would look like

=A1 & CHAR(8232) & B1

If you were in Microsoft Excel on a Mac, the analogous command would be CHAR(13); on a PC it would be CHAR(10).

Automator Workflow for getting creation datetimes

My day job involves grant applications, and we have a long way to go when it comes to gathering data on our performance. It’s been my feeling that our workload has been increasing over the past few years, and that we have boom and bust cycles. A count of proposals is an easy way to verify the upward trend in overal production, but looking for the cycles requires data that we’re just not logging. Continue reading