Get instant live expert help on dollar signs in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

the results of my formula newname = ActiveCell.Address is $T$22. I need to have the answer be without the dollar signs as T22. How can I process the $T$22 to become T@@?
Solved by C. W. in 28 mins
Assume that you initially only want to see the employee's first name in the "name" cell. What formula will give you this piece of information? Since the formula will not be copied to other cells, do not include any dollar signs.
Solved by M. H. in 17 mins
I have imported a file and need to format a column that is set up including the dollar signs to allow me to total the column. The only way I have found that works is to go through, cell by cell, and remove the dollar sign. Specifically, I am trying to total Column H on the Direct Charges report.
Solved by C. D. in 25 mins
I need to delete the @ signs in the email column and leave it blank.
Solved by B. J. in 20 mins
what are the signs for muliplying, adding and subtracting
Solved by E. H. in 23 mins