Using Excel spreadsheet for SmartTerm macro

Hello

Please re-direct me if this is not the right forum for my question. I use Excel spreadsheets to populate data points in my Cache application using SmarTerm macros. This issue is not truly an Excel Macro issue, but more a generic Excel question.

So the problem. One of the fields I am trying to populate in Cache should read ^CAL, and SmartTerm picks it up just fine but Cache sees it as part of a Control code, in this case CTRL-C. I need it to be interpreted as just a plain old ^.  I'm not even sure this is an Excel issue but so far I've had no luck using all the suggestions in the SmartTerm macro guides or anything I can find in the Cache documentation.

I'm thinking maybe replacing the ^ with the ASCII code, with the correct formatting for Cache will make it appear as text and not a Control code. So far, no luck.

Any help is appreciated, and if I am barking up the wrong tree, let me know that, too. Like I said, I'm not sure this is an Excel "thing".

Thank you for your time.

Dave