There are readly available macro samples on the web that can do that. But it is much more difficult to do it with a formula.
No macro is not "Mac". It means using code instead of formulas
Ok give me about 30 mins to write the formulas on an excel file, but you will need to upload it yourself to Google Docs
Ok here is a test file for your review
(make sure to click the blue DOWNLOAD button at the bottom of the download page)
Try it by entering different values in cell A7 to see how it works. If it is ok I will send you the full version
Thanks. Ok you can pay the balance using the Add Bonus button while I prepare the final version
Ok I have the final version ready now.... Let me know if you cannot find the bonus button
Here is the file. The final formula in B7. The auxiliary formulas are in helper columns C thru V which you can keep hidden if you like
You can copy the formulas down to as many rows as you like, but make sure you also copy the formulas in columns C thru V
Let me know if you have any questions
Just drag cell A7 and drop it in M12, and drag B7 and drop it in B15
How do you get to which rows? All rows and columns are accessible and you can get to any of them
Do you mean "columns" not "rows", right?
I still don't understand what you are saying. If you want to make use of columns A thru V, you can shift the entire set of formulas to the right of column W. Just select column A, and keep inserting columns until the number field gets shifted to column W, and with it all the other formulas will be shifted
Great. Glad I was able to help
Please send me your new file so I can try to set it up for you
No I need the actual Excel file
I am afraid we are not allowed to make phone calls on this site. You can use the paperclip icon on the toolbar.
We cannot use email either
Please go to http://www.wikisend.com/ and upload the file (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
I got the file.
Please list the cells in that file that have the numbers which need to be converted along with the cells where the corresponding words should appear
So what do you want me to do then?
Please just give me the cells that need to be converted on one sheet. I see hundreds of numbers in different rows and columns and I have no idea which is which
So I am not quite sure what I need to do with this file unless you tell me exactly what you want.
I think this question is getting quite extended (this is about the 25th message since I sent you the file with the formulas). Perhaps you should consider opening a new tickets
Those cells that you mentioned (i.e. cells d43 d48 and 50) on which sheet are they on?
On that sheet there are no values in cells d43 d48 and 50. I will I assume that you meant D42, D44, D49 and D51.
Will set up the formulas on these cells and get back to you
Ok let me know when you're back online so I can send you the file
Ok one moment...
Ok here you go
Hope this helps