Search code examples
excelms-office

Does the Lorem or Rand functions exist at all?

So I saw on numerous websites there was such a command as LOREM() to generate Lorem Ipsum text, and RAND() to generate example text in your system language. Some mention only Excel, some mention Word, Excel, and PowerPoint (are there functions on these?) and some only Word and PowerPoint.

I tried inputting those in my Excel Sheet to no avail. My Excel is in French, so maybe the translation is wrong, but there doesn't seem to be any page on those two functions in support.microsoft.com… LOREM() shouldn't be translated in anything else than LOREM() anyway, so I'm puzzled.

Are those two real, or is that an office urban legend ?

Solution

  • Since it seems to not exist in Excel, the solution I have found is to use =lorem() in Word, and copy/paste into Excel. I doubt anybody in this forum requires that answer to be stated, but hey, maybe they are lacking coffee and need a jolt of the obvious.