Problems with Formulas I\'ve been an avid PC uuser and my current job (4 days in

Question

Problems with Formulas

I've been an avid PC uuser and my current job (4 days in) has mandated use of a Mac. Not happy about it, but I'll live. I seem to be having trouble with formulas being accepted. When I hit enter, the formula continues to display. It will not calculate, or even give me an error. I thought I was going nuts, so I did some googling and found the same syntax. When I copied and pastedd from a web page, it worked! I'm racking my brain to try to figure out why typing it in won't perform a calculation, but pasting it from a web page will. Any ideas? Help!

I was attempting a sub (=Substitute(A1,CHAR(10),",")

Simple enough. When all was said and done, it did at least take out the carriage return, but it still didn't populate the (,). Iss there something I need to be adding to the syntax to speak to Macs?

Explanation / Answer

In addition to insuring that calculation is set to automatic, you need to realize that the line endings on Mac and PC are different. If you are really looking for an ASCII 10, that's fine. An ASCII 10 is ASCII 10 on both platfoms. However, not to quibble but an ASCII 10 is a line feed, not a carriage return which is an ASCII 13.

Depending on how thee data gets imported into the work sheet, the platform OS may actually change the line ending character. So be careful.

And by "attempting a sub" I assume you mean a ssubstitute, not a subroutine. In either case, the bounding parentheses are not neededd.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.