Word With Hexadecimal Numbers
Nov 15, 2012
I have a word file that consist of titles followed by hex numbers that I have tried to bring into a excel spreadsheet. Since the Hex numbers have leading zero's I have tried converting spaces to comma's then saving the file to a plain text file then bringing it into excel but have mixed results. The first column is correct but all following colums revert back to general format even though the Text box is checked and the delimiter is the comma. I can upload the actual file which are a number of commands and pronto codes for a Harmony Remote Control device. Logitec has asked me to send these codes to them in excel rather than word. This seems a bit more complex than a normal small file that is illustrated in prior post.
View 3 Replies
ADVERTISEMENT
Nov 16, 2004
I am using decimal and hexadecimal numbers. On a worksheet I can use all of the normal functions for this problem (Hex2Dec etc). I have loaded the Analysis toolpack, and also have an add-in loaded (but do not know how or when) that is called Analysis ToolPack VBA. In VBA I can use the fnction Hex to convert from decimal to hex, but there does not seem to be a reverseof this function. Am I missing something obvious or is this a 'hole' in the available functions? Is there a reference I ned to add in the VBE? if I try to use the worksheet function in VBA then I get a Value# error.
View 7 Replies
View Related
Mar 19, 2013
I need to be able to convert big hex numbers into decimal numbers. The problem that I have with this is that when you put a hex number that includes letters excel considers it text. And if the number is too big, you can't convert it to decimal format, and when you try to, it comes up with the #NUM! error.
Number: "78652385098375A879FF747C9847A00" without quotes
View 4 Replies
View Related
Dec 23, 2012
I need a vba routine that paints a cell as its contents.
The content in this case is a hexadecimal color code.
For example: if cell A3 contains the code # 000000 the cell will turn black if I change the code to # 00ff00 the cell turns green (as this hex code).
I wish this option was available for all cells in the range A3: Z80.
View 3 Replies
View Related
Jun 9, 2007
I read the thread Converting from Hexadecimal to Binary and what I need to do is convert the following hex number to binary; 9E6799CF. The function in that thread doesn't seem to handle that large of a hex value. Is there anyway of doing that with a HexToBin function, short of chopping it up converting the smaller numbers and recombining it in binary?
View 2 Replies
View Related
May 31, 2008
I use hex2dec frequently and input with a hex 'E' such as 05e8 is misinterpreted as exponential notation. I can use =hex2dec("05e8") to get the correct value, but when the hex number is in another cell, I get the exponent assumption/ conversion (to 5 x 10e8), or a # NUM error if it is in quotes. This seems like a blatant problem but I've found no mention of it in searches or FAQs.
View 3 Replies
View Related
May 9, 2008
Well it look pretty simple but is it possible.
What I have is a list of code.
KLJBC1234
KLMS234
KLVS12344
KLJBC235
All the numbers at the end is unique. So what was planning to so is just take the numbers out. As you can see is range from 3 to 5 number. Is there a formula to just pull the numbers out? max
View 9 Replies
View Related
Mar 7, 2014
I want to split the names from the number and then merge column Desc and 2nd Line Desc?
Desc
2nd Line Desc
AMAPOLA CREEK CAB SAUV 750ML -- 75817-17
SON VLY
View 1 Replies
View Related
Dec 9, 2013
I have a few hundred word files that I'm porting tables from. I initially imported every table into excel and figured out which table numbers I needed the data from. I only needed certain rows/columns from certain tables.
The code I have works great....if all the word files were the exact same. However, it appears that when different people edited the word documents, for whatever reason, a handful out of the 300 had their tables switched. So in some cases I'm looking for table 5, other times it could be table 6.
My question: Is there a way to identify the tables by text they contain? for example, the table 5/table 6 comment above, in all cases That table has a header cell called "Equipment". Basically I need something like:
"If CurrentTable contains "Equipment" Then set tableNo = CurrentTable" but I'm not sure how to do that.
In the code below wdDoc is a specific word document. tableNo is the variable set to identify which table to import from. I end up pulling data from three different tables that I would need to search for, each with a specific header.
Code:
With wdDoc
tableNo = wdDoc.tables.Count
tableTot = wdDoc.tables.Count
If tableNo = 0 Then
MsgBox "This document contains no tables", _
vbExclamation, "Import Word Table"
[Code] ........
View 6 Replies
View Related
Feb 6, 2007
In a word file, I have a list of ID numbers. I want to paste them into a excel file, but the problem is that the last 3 digits of every ID number are converted to "000" no matter what they are. The ID number has 18 digits.
View 9 Replies
View Related
Mar 2, 2007
I have a file with a lot of numbers, but one column with single digits. These digits have a cooresponding model name. I want to convert them all to their model name. There are only 4 model names. I tried a nested IF statement, but felt this wasn't working properly or was not the proper formula choice.
A Find/Replace would work, but it picks up the single digits elsewhere in the sheet. I realize i could copy/paste my column to a new sheet and from there convert/paste, but I am trying to get better at Excel.
View 4 Replies
View Related
Aug 16, 2009
my new payoff worksheet and then this small bug appears and my excitement like "poof"(gone)!.
with this code --> =if(search("ins",i27,),LOOKUP(99^99,--("0"&MID(I27,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},I27&"0123456789")),ROW($1:$10000))))+0
i can get the value if the word contains "ins" like this --> "Ins 723.00" return 723.00 which is correct, and then i've encountered a word which is like"723.00 Ins", and martin gave me the code to get from both sides which is this one --> =IF(ISNUMBER(SEARCH("Ins",A1)),LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000))))+0,"") . Work perfectly. and my big problem is that the word Ins 723.00 means Insurance and the 723.00 means Inspection, so it means they're different. and it means I cant use martin's code with this.
So is there any way i can get only the value if the word Ins is in the right side of the amount and also the code if the value is in the left side of the amount. I need two formula for this.
View 4 Replies
View Related
Jan 17, 2010
I have a very large list of top scorers for a sports team MS Word. The name and number of goals are both on the same line. Is there any possible way I can past them into Excel, so as they are pasted into 2 separate columns?
View 2 Replies
View Related
May 26, 2006
I have an excel program that is supposed to count word instances in a word document. I can't seem to find the right declaration for a word document.
For example to declare a workbook in excel its
Dim wb As Work Book
I've tried
Dim doc As Word.Document
'or
Dim doc As Word.Application
as shown in some of the forum posts, but an error user-type not defined keeps displaying.
View 2 Replies
View Related
Oct 30, 2013
I am trying to identify the row(s) where a match occurs when there can be multiple occurrences of the match.
A
B
C
1
john brown
Brown
True
2
Cathy Smith
3
Brown excavating company
4
XYZ Corp
5
Brown Advisors Inc.
The first test I ran in cell C1 with the information above was to determine if "Brown" was located in the range of A1:A5 using formula:
=IF(ISNUMBER(MATCH("*"&B1&"*",A1:A5,0))=TRUE,"True","False")
In the case of the word "Brown" it occurs in the range of A1:A5 three times, so the result of the above formula would be "True"
Now what I would like to do is return the locations, in this case the row number(s), where the word brown is contained range of A1:A5 because in the case of the word Brown, it occurs three separate times in the range of A1:A5. I would like the resulting value of the formula in this case to be "1, 3, 5" indicating the word Brown occurs in rows 1, 3, and 5. The formula also needs to work in case there is only one match as well.
I tried using the below array formula:
={MATCH(FALSE,ISERROR(SEARCH(B1,'Working List of Vendors'!$A$1:$A$5)),0)}
But it would only return the first occurrence of the match which in this case would be row 1, or "1"
View 8 Replies
View Related
Apr 10, 2013
I am working on word documents that has financial numbers on them. I am copying word pages to excel to calculate the numbers by using formulas and etc. I will cut to the chase; is there a way or a macro to insert into an excel template workbook(.xltx) when we open the template there will be a command button to select the word document (which we want to copy its pages) to excel sheets. When a new page begins a new sheet will be created and the page will be pasted on the new sheet.
It is not important if it has to have a command button to select the word document it is ok to run the macro and select the word document and it does not has to populate sheets according to length of word document (I can create lost of free sheets on the template)
The main idea is to gain the time I spend on copying the word document to excel sheets. Some documents can be very long (100 pages). I am using MS Office 2007.
I triend to export data but excel does not allow me to select word documents.
View 5 Replies
View Related
Jul 29, 2009
if you can remove the word total from each cell without deleting the numbers after you copy from a subtotal list?
View 9 Replies
View Related
Jul 6, 2009
Is it possible to export Excel cell contents to Word fields in a protected Word document? For example...
What code would be needed to tell Excel to open up, copy and export the contents of A2 in the active sheet of a workbook to "Field 2" in a Word document named "Report 01" and then put the contents of B2 to "Field 2" etc?
Do both applications have to be opened up at the same time or is Excel able to open up Word on its own? Will the macro be able to....
1. Automatically open up the correct Word document?
2. Look ONLY in a certain folder for the "Report 01" Word document?
or
Bring up a "selection" box that allows you to select the document you wish Excel to export it's data to?
3. Close and save the Word Document without any user intervention?
View 2 Replies
View Related
Feb 16, 2012
I need to count how many times the word Test is in the range B4:H9 with
Range N2 = Test the formula below works if Test is only in the cell once.
=COUNTIF($B$4:$H$9,"*" & N2 & "*")
But I have data in cells like below, this is all in one cell, so how would I have it count all the times test is in the range when some cells have test 2 or more times in a single cell?
5
Test
8am-2pm
Test
5pm-10pm
View 5 Replies
View Related
May 6, 2009
How can I use the IF function, to make entering a word, space then word display correct and incorrect if not.
View 13 Replies
View Related
Sep 3, 2009
I need my macros to search for the word "Cancel" or "Cancelled" in columns "T" and "U". Once found, I need the macros to make that entire row an opaque shading.
There will be other wording in these cells that contain "Cancel" or "Cancelled". Is it possible for the macros to search in the sentence and find the words "Cancel" or "Cancelled"
I started on the code below but am stuck.
View 14 Replies
View Related
Jun 9, 2009
Have problems using find and the Dictionary
What Im trying to do is find a certain word in a string then return the number associated with that word
View 7 Replies
View Related
Jan 4, 2012
I am trying to automate the below process:
1. I have a excel file with Japanese words in column A and their English equivalents in column B.
2. I am trying to create a Macro and assign it to a button. On pressing the button Macro should be able to:
3. open a form where I can enter location of a word file.
4. Macro should open the word file specified in (3).
5. Macro will pick up first Japanese word from excel file (Sheet 1 - A1)
6. Search for that word in Word file
7. Replace the Japanese words in Word file with their English equivalent from excel (B1)
8. Then it should search for second word (A2) and replace with its equivalent (B2) and so on till it reaches last filled cell in excel file column A.
After a lot of search I could find a code from net (Below), made a few changes, but it is not working.
========================================================
Private Sub OK_Click()
' Requires a reference to Microsoft Word xx.x Object Library
Dim sFile As String
[Code]....
View 1 Replies
View Related
Mar 14, 2014
I would like to have a formula find a specific word in column L and return the sum from column E for the same fund from column C.
I tried using =SUMIF(L:L,"*annual*",E:E) but that gives me the sum of annual for the entire column. I need to be able to specify the fund.
word "annual" also appears in "semi annual" so I need to be able to separate the two.
View 5 Replies
View Related
Jan 22, 2013
I want to say if the word 'suitcase' is in column W (any row), place the word 'suitcase' in column Z, same row.
View 2 Replies
View Related
May 1, 2009
I am in the middle of automating a process here at work, the program takes a word, "pencil" for example, from excel. It will then open up a word document with content already in it (premade template). The program will then find all instances of a string, "placepencilhere" for example, and will replace that instance with the string from excel.
Basically I want to be able to take a variable that has a stored string value from excel and use it to replace another variable in a word document.
I tried recording a replace (ctrl+f, replace tab) macro, copying the code, and inserting it into the excel vba code.. but I get a error message. Here is what I have:
---
View 11 Replies
View Related
Jul 18, 2008
I have a bunch of cells in column b that have products.
Column B
Dell 24" lcd
vaio sony laptop
8.0 mpxl kodak camera
photoepsonprinter
Basically in Column A I want a formula that'll say.
If the word "dell" is somewhere in cell b1, then put the word "Dell" in cell a1.
If the word "sony" is somewhere in cell b1, then put the word "sony" in cell a1.
And then so on and so forth down through column A. The brand names are potentially endless, so is there a easy way to on like a seperate sheet make a list of brand names and have it pull from there?
Originally I made a if function that said if the brand name was contained in the cell then output the brand name, but that caps at 7 for the amount of brands i can use....
View 9 Replies
View Related
Jan 22, 2014
01. I want to Type "Al Raha Pharmacy" in a cell
02. When I type "Al Raha" and I press space, then the word automatically changed to "Al Rahma"
03. I tried this in other cells also but the result is same.
View 1 Replies
View Related
Dec 7, 2009
I've imported a lot of data and it looks like this:
blahblahblahWord 1 Word 2 Word 3
First, I want to erase the "blahblahblah"
Second, I want Word 2 to be bumped over to the next column and Word 3 to the column after that.
Is there a formula to do this? There's so many rows of data that it will take a long time to do it manually.
View 9 Replies
View Related
Feb 27, 2014
I'm going to be using a spreadsheet to keep track of where different people are at. So if Person 1 is in Room 3, I will stick a 3 in the box next to their name and then can look at the spreadsheet whenever I need and see what room they are in. When I'm deciding what room to put a person in, though, I need to be able to quickly glance at a list of Room #'s and see what one's are still available. So I have a bank of Room #'s in the spreadsheet....1,2,3, etc.
What I'd like, is some way to set this up so that when I put, for example, "3" in the cell next to "Person 1" the spreadsheet automatically removes "3" from the bank of available Room #'s and when I delete the "3" because the person has left, it adds "3" back to the bank of available Rooms.
View 7 Replies
View Related
