Saturday, April 29, 2017
Thursday, April 27, 2017
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
Saturday, April 15, 2017
Thursday, April 13, 2017
Thursday, April 6, 2017
Wednesday, April 5, 2017
Monday, April 3, 2017
FileMaker Pro (FMPro) great command for copying field info from one field to another
https://www.teamdf.com/blogs/the-replace-field-contents-command-why-it-is-so-cool/
Use the calculation formula to get values from a different field.
Use the calculation formula to get values from a different field.
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:
Subscribe to:
Posts (Atom)