Αποτελέσματα Αναζήτησης
11 Μαΐ 2012 · Concatenate to fixed length field. Hello, I have 3 fields that I need to concatenate into a 10 byte string. Field 1 will always be 1 byte, field 2 is 5 bytes and field 3 is 4 bytes. If the value in any field is less than the expected number of bytes, I need to have it zero filled. So I am looking for a formula to turn 1 20 301 into 1000200301.
22 Αυγ 2011 · Re: Read two text files without opening and write to another. Yes, in the link file there can be multiple of the same ID's and i want all of them to be captured. Think of it like a relational database, the ID file has one column that is the primary key and the Link file has the same column in it but that column is a foreign key in that table.
25 Δεκ 2014 · Re: Question marks appearing when I convert excel spreadsheet to txt file. The only thing that I can think of is that your regional settings may be causing the problem. The encoding might also be a problem. Both files that I sent to you were Western European (Windows) encoded and they were both perfect here.
11 Ιαν 2010 · Re: Best PC Setup for running heavy VBA Programs. From my experience, you have two major variables... RAM and speed. If you are using Excel 2010 then you should make sure that it was installed as 64-bit instead of the standard 32-bit. This will allow you to go over hte 32-bit limit of using 2 GB of RAM per application.
10 Αυγ 2013 · Re: Translate VB Code into Office Script. Your code for setting a selected range to "Yes" is a little dangerous (as I discovered). Your code selects Sheet1 so, regardless of which sheet you have selected, Sheet1 will be selected anda cell, or cells, could be corrupted (if Sheet1 exists).
19 Μαΐ 2013 · Re: Using VBA to lookup values in a csv file to an xlsx file. Yes, both Application.ScreenUpdating = False and Application.Calculation = xlCalculationManual will speed things up considerably. (Don't forget to set SU to True and do a manual Calculate at the end of the macro.)
23 Φεβ 2007 · Thank you in advance for any assistance. When copying text (in this case product ingredients) from a webpage to a cell in excel, the text copies ok, but as soon as we try to wrap the text to fit, it goes into a strange format. No amout of paste special or different formatting makes any difference. Please see the example attached of when copied ...
3 Οκτ 2005 · CellValue = rng.Value 'go through the string character by character (note that 'each character is 2 bytes - you just don't see it) For i = 1 To Len (CellValue) 'get the unicode value for this character UnicodeChar = AscW (Mid$ (CellValue, i, 1)) 'append this to our string - as unicode NewValue = NewValue & ChrW (UnicodeChar) Next i 'Write our ...
28 Ιουλ 2014 · Forum Guru Join Date 05-10-2004 Location Essex, UK MS-Off Ver O365 Posts 20,472
13 Σεπ 2024 · Excel Formulas & Functions. [SOLVED] Keyboard Shortcut for Choosing All Empty Cells. The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed. HOW TO ATTACH YOUR SAMPLE WORKBOOK: Unregistered, Fast answers need ...
