I am trying to use this simply command to put ' ', around a cell so I can use it to pull many strings from SQL. For some reason, it works in one of my spreadsheets but not my current one. What would cause this? I have had my excel repaired twice. Any suggestions? I did change file from compatibility mode. Didn't help. Thanks.