I am using an exported dbf from filemaker pro. This is an established dbf, with over 2,000 sku's in it. Here is what I want to do.
I am using Indata and InDesign to create a catalog. I need for excel to pull the first character from a cell and put it in another cell. i.e.
I have a dbf where I have author last name, and title of book. I need for excel to pull the first character of each of these fields and put them in their own cell/column. This will allow me to use these new columns to make the " headers" for my InData/InDesign doc.
I have a cell which will contain SER01+SER02+SER03
and what i need it to contain is [SER01]+[SER02]+[SER03]
and shocker is i've got this to work for the first instance but not the other two
code as below... be grateful for your help
Sub measure1() Dim list As String, pos As Integer, refl As String, refr As String, newlist As String list = Cells(1472, 16).Value pos = InStr(list, "+") refl = Left(list, pos - 1) refr = Right(list, pos + 1) newlist = "[" & refl & "]" Cells(1472, 17) = newlist End Sub
I have a column of numbers each have a 0. infront of them (example 0.2346 0.5698). I want to pull the number from the right until it hits the decimal sign. So for the two above the result would be 2346 and 5698
I have got a list of numeric abbreviations, for instance 10739011/21/31/41. What it should really display are the numbers 10739011, 10739021, 10739031 and 10739041 (the first six figures stay the same). All the numbers in my list are 8 figures long. I want to change the list from the list seperated by the backward slash to the complete numbers. I have uploaded an example of the list with backward slash between the numbers. Is there a way that Excel can automatically change these numbers to the full numbers?
Because all the numbers are 8 figures long, I thought the first 6 figures of the 1st number can be copied and those 6 figures pasted before the other two figures after the backslash. Auto Merged Post Until 24 Hrs Passes;sorry, pressed OK too quickly. The problem is that there are sometimes 4 numbers in the cell, sometimes 6 and once three. I would like Excel to complete all the numbers in the cell and then move on to the cell underneath it and so on. Also, I would like each number to have it's own cell.
I have a string of text in cell A2. In cell B2 of my spreadsheet is a formula that calculates a number based on the text string in cell A2.
I want to write a VBA loop that removes a single character from the cell A2 string, then calculate the new value in cell B2. I want this loop to continue until the value in B2 falls below a set value (in this case 60).
My code so far Sub trim_text() Dim mytext As String Dim myanswer As Integer mytext = Range("A2") myanswer = Range("B2") Do While myanswer > 60 mytext = (Right(mytext, Len(mytext) - 1)) Loop End Sub
This obviously does not work. In my excel table I have a formula in cell B2 to calculate "myanswer" will this work, or does that code have to be placed into the VBA code?
I have a column with unique identifiers (numeric) that are included in another column. I need to find this number in the column and pull the data from that column into a new one. For example:
Unique Identifier: 28530
Is included in this string: 10.1.8........28530_201_10-....
I need the content from the string pulled into a new column. It seems there would be a LOOKUP that would work, but I'm not able to figure it out.
I am in need of a way to pull keywords listed in B2:B10 from text in A2:A10 and then those pulled keywords combined in cell C11.See attached document. So I have colors for keywords in column B and some random text in the column A including the keywords in parenthesis. Is there a way for a formula to find all keywords in A2:A10 and then list them in cell C11 with commas in between.So the result would be one cell C11 showing BLUE,GREEN,BLACK,ORANGE, etc.I have been trying to mess around with index and match and while I could get one to pull up I don't know how to combine it.
I have many workbooks which all have a summary sheet called summary, and which are all kept in the same folder (although this folder name/filepath may change from year to year).
I want to be able to set up the column headings and then copy the same set of summary information from each book so that it can then be used for analysis. The cells to be copies derive their value from formulae, it is the value that needs to be copied.
I attach a workbook with the format needed and the source cells. The source sheet will be password protected.
I know this is a question that has been raised before and I have searched the forum but not come across a question that is close enough to work from - my VB skills are appalling.
if a cell contains character A THEN multiply by cell B * 0.02,if a cell contains character B THEN multiply by cell B * 0.05,if a cell contains character C THEN multiply by cell B * 0.010
i have a column that is 1900 long and i need to add a "comma" to the end of everything in each cell in that column. How do i go about this? so at the moment it look like this:
I want to test a cell for the type of value as 678/256 or 345/872/098/987 etc. The common character in each would be the "/". First, I need to check the cell for this, then take the first number and compare it to an integer(if it is <> , or = to). I hope I am clear with my situation.
I'm using the hidden-row trick to auto-fill cells beneath the hidden rows.
For this to work, every cell that is to be auto-filled in must have a character in every cell above it.
How can I make sure that my unfilled cells always have a character in them? If a user deletes the contents of the cell, I want a single character to stay in the cell (I want a backslash). This way, there will always be either a backslash, or the user-filled data in the cell. It can never be empty.
I am creating a macro that saves a file using the value in X1 as a variable name to save the file. I want to check if the last character in cell X1 is a period ("."), and if it is I want to either remove the period from X1 and continue to save, or tell the user it is not possible to save the name that ends in a period.
I enter for example in a cell : 0625-C0/01 sometime 0 is entered as O a letter and not zero.Is there a way to ensure that only 0 (zero) is allowed in that string using data validation rules.
I have spread sheet with 2 tabs (MASTER LIST & CYCLE COUNTS), on each tab I have 2 columns(LOCATION1 & DATE1 and LOCATION2 & DATE2) I need to verify if I any cell from LOCATION1 is repetead on LOCATION2 and copy the informacion from DATE2 to DATE1. then if I update the CYCLE COUNTS sheet I want the MASTER LIST update by it self.
This is the formula that Im using but Im having problems with the range..... =if('Master list'!$A2$:$A$15000='Cycle counts'!$A2:$A$15000, 'Cycle counts'$B&2:&B&15000,0)
I want to be able to identify an Excel workbook in a cell, then have another cell pull the value from a specific cell in that workbook.
In the sample attached, I want the formula in cell C4 to pull the value in cell D35 from the workbook identified in cell C3. When I click within the brackets [C3] it asks me to choose a file name from my Explorer file list. "='[other_workbook.xlsx]Audit Information'!D35. I don't want to do that and want it to choose the file listed in cell C3.
I am trying to get excel to pull the value from a certain cell. The value is pulling correctly when I use whole numbers. But if I format that value as either a decimal or percentage it does not recognize it and only pulls over 0.
I have this formula I use to pull the date and time that they place in 1 cell from a customer quote sheet. It was working well until we got to a double digit month.....
The thing is they are inconsistant in stating the dates. such as "09/03 10AM" or "9/3 10AM" or even sometimes "9/03 10AM".
Is it possible to pull only certain information out of a cell?
I have in cell A1 (As of 6-30-12 and 5-31-12) i would like to put a formula in cell b1 to pull just (6-30-12 and 5-31-12) so that everything i change A1 B1 will also change.
I'm making pull down menus to auto fill in some options in my Cells... such as
"Open" "Closed" "Work in Progress"
what I would like is to have the menu also enter text formatting... so that I can have "Open" entered in RED and BOLD... and have "Closed" Entered in GREEN and Italics.
I want to use an excel formula to find the Nth instance of a string in any string. I realize that I could right a UDF for this but find that to be a poor solution.
Attached is a sample workbook where in cell 'C1' I want to extract from A1 just the supplier name and leave the supplier number behind. As the string length of the supplier changes,I cant use the left function that I would normally doI racked my brains on this and I'm sure I've seen it done before cant remember where.The string length of each cell is 21 digits with padded spaces to the right of the cell. If it helps the number of spaces in between the supplier and number changes each time.