Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Bruce Wilner Your Own Question

Bruce Wilner,

Category: Microsoft Office

Satisfied Customers: 76

Experience: principal at Network Security Labortories Inc.

94527327

Type Your Microsoft Office Question Here...

Bruce Wilner is online now

Just for background, the file is data file for a stock

Customer Question

Just for background, the file is data file for a stock market application. The code that I am focused on is a way of determining whether the high or low came first in each specific period. I had developed the code in 1 file and wanted to transport it to another file. So I selected all the code and did a replace of the "=" ,the very first character in the expression and replaced it with "#"The first problem is that result of that operation was that some of the sells have "#" then the rest of the expression, and some have (quotes excluded for clarity) '# The second problem is that I cannot get back the original formula with the proper syntax. I

Thank you for using JustAnswer.com. My name is ***** ***** I will do my best to help. Please give me just a bit to look over the question and do some initial research. Thanks, Bob

I sincerely ***** ***** never open any .zip files - if you want to include the Excel spreadsheet, that is OK. Otherwise I will respectfully ***** ***** another professional can take a look.

Note: Please disregard the offer for "Remote Assistance", it is automatic on our 2nd response.

To make this easier to visualize, I have included 2 screen prints. The first is of my data file. The last 2 columns on the right have either a "1" or a "2" in them. It is a way to determine whether the High or the Low came first in each period. Then the cells are color coded. They show a nominal 3-day (or period for time periods less than 1-day) cycle.i.e. This is the Taylor Trading Method. The 2nd screen print shows the formula for the cell.So, what I wanted to do was copy these formulas to a new data workbook.To do that I tried to substitute "#" of "=" in each formulaThen the idea was to move them all to a new workbook and change the "#" back to "=" and have all the formulas work. (I have 1 file that has 26 lines of formulas,which is for a sample of every 15 minutes. I have 1 vile that has 120 lines of formulas, which is for a same of every 3 minutes)The enclosed excel spreadsheet shows what I got when I did the replace.some of the expresses got the substation correct, but some cells have " '= ".I would like to know why this replace did not give me consist ant results and what replacements I need to make to get back to the original formulas.

Lets review the problem. I start out with formulas in 2 adjacent columns. there are really 2 problems: 1. the change from formula to string does not result in uniform results. some of the original formulas come out as "# then original expression" and some come out as " '# then original expression"2. I cannot change them back into their original formulas.I want to change them into strings to move them to a different workbook without changing there relative addresses. (I hope I said that correctly)