Tuesday, April 25, 2017

Reconfiguring secure printers at Adobe


  • Delete the existing Secure Printer entry
  • Open the Self Service app on the Mac
  • Click Printing category
  • Install Secure Print 1.0
    • Choose location for where I am

Sunday, April 2, 2017

How I figured out what invisible character to cut


  • Copy paste character to own line in Excel
  • Then used function =CODE(targetCellRef)
  • Then used: =TRIM(SUBSTITUTE(A4,CHAR(202),CHAR(32)))
  • https://support.office.com/en-us/article/Remove-spaces-and-nonprinting-characters-from-text-023f3a08-3d56-49e4-bf0c-fe5303222c9d
To get it working in VBA script I used:

temp1 = WorksheetFunction.Substitute(Rng.Value, Chr(202), Chr(32))

Rng.Value = VBA.Trim(temp1)

Modified from: