Wednesday, 11 July 2018
Microsoft Excel - Generating test data
We had a requirement to generate some test data within a Microsoft Excel spreadsheet.
similar to this: -
This was the magic invocation: -
="Subscriber Reference #"&ROW()
We merely needed to copy that to the clipboard, and paste it into a nice chunk 'o cells ….
So it's a piece of text concatenated with the row() index, using the ampersand ( & ) symbol.