User Define Function to Text in Excel

Create a UDF in VBA that, after entering, turns itself into text / number of your choosing.

UDF

Learn how to create a VBA function in Excel: =GUID() is the example here where you enter that into a cell and get back a GUID. If you look at the VBA code, you can see another Excel formula there that creates a random GUID.

Convert to text

See an example of the =GUID() function in Excel that converts itself to a value in the cell. So users can use a function to trigger getting text in the cell.