Search results

Beatiful.... thanks

Hi Everyone, Trying to import a text file in Excel. The file is one long column of addresses separated for the most part, by the hard returns. The import wizard did not cooperate very well; even when I tried to use the ALT+0020(or ALT+0010). No luck. OFFSET formula is a pain to deal with--...

Hi Guys, Thanks for the additional support. @ Dan_l -- agreed. I do not like the Cubs either... Cubs my nickname and yes the client demands transcend ridiculous. You really don't want to know the hoops they have us jump through...not pretty. @Hui-- understood and will do. I'm going to...

Hi Guys, and thanks. I'll have to plug in some of these options and see what works. @LukeM and JP-- I did initially consider the solver since I am familiar with the add-in. It could work but, the issue is I need to run this calculation for over 1000+ rows,all working out to various multiples...

Hi All, Ok, here is the deal. I'll be as short and succinct as I can. I need to find a way to change the core values of cells. For example, let's say I have 5 cells with the following values-- 23, 46, 67, 12 and 56, which add up to 204. Once we have the total, I now need to change the...

Hi Everyone, Ok- I'll admit this question is subject to interpretation. A lot of people in my office are looking for "file size management techniques", or put another way they cram a lot of data into a workbook, it loads slow and now they want to fix it. Any thoughts.... Thanks, Dave

Hi Luke, To be honest, I'm not 100% sure. My guess is there are a lot of multiple hands in the pot and no one is willing to confess to their actions. I was not aware of the add-in, I'll check it out. Many thanks... -Dave

Hi Everyone, Here is another question. Why do some Excel files change number formats on opening – often to Euros? The region setting on my machine are set to the Eastern Time Zone, USA Thanks, Dave

Hey Guys.... Most awesome!!! You ROCK!!!

Hi Everyone, My name is Dave and I have been using Excel for a decent amount of time and am currently wresting with my nemesis- date calculations/ date formulas. I am aware that Excel uses serial numbers with dates and times. Please allow me to describe my issues and pardon any...