extract cell value

Hi, I hope someone can help. I am trying to create a command within a master document that will loop through a folder and extract values from specific cells and paste them to the master document. The folder has hundreds of individual files, all named differently, and each file has multiple...

Hi Dear Allz, I am trying to extract values from preceding rows based on a value which is given in next columns. Like in following example, in cell A2 Cell value is 10 (Highlighted in Green) the corresponding value in cell D2 is 3 (Highlighted in Red) so the value required in Cell E2 is...

So the column has a mixture of this: row 1 has textnumber and row two has only number. This column has thousands of rows with formats like row 1 and row 2. Text123456 350.50 I only want to extract the 350.50 to another column so I can get a sum and do that for the whole column...

Hi, I am new to VBA in excel and would request your help to solve my problem. I am currently working on a problem which involves extracting unique string values from 14 disjoint columns in excel. Each column in my data has around 500 string values with few blank cells in between. The 14 columns...

Need a formula or macro to extract specific info Below in bold is what I am pasting into Excel as 1 column, 4 rows I don't care about row 1 I can use LEFT function to get the 1st 6 digits. My issue is how to I get middle (example 2,405.66 in row 2). My issue is there is no consistency. /1...

Hello, what formula could I use to extract the second to last and third to last numbers from the below string separately? I want to pull 4.410 out and then the 5.007 out. 704938 1-6/9" Dia. 12L14 Metal Row Hard 1 5.007 4.410 4.4330 the string is located in cell A10. I extracted the last...

Hi, I have some text in column A similar following table and I want to extract timings after 04:00 PM, <tbody> Timings Output <colgroup><col width="319"></colgroup><tbody> 03:15 PM, 06:15 PM, 09:15 PM </tbody> <colgroup><col width="190"></colgroup><tbody> 06:15 PM, 09:15...

Hi Team, is anyone help me with below requirement ...in the given example string ...need to eliminate what is there in brackets and need the numbers in each line. If you see ** thes two stars will separate the each numbers in each string. I believe based on the these stars need to build the...

Dear All, I have single cell having remarks of work done. I need to extract the data based on two conditions. I'm already using below formula which returns the word in cell but not fulfilling the condition I need. Relay & Capacitor replaced =IF(ISNUMBER(SEARCH("Relay",$T64)), "Relay", "")...

Hello, This is my first post on this forum. I have been tasked with compiling data from the same column in many sheets (290). -The sheets are all in the same workbook and have an incremental name (SO17000-SO17290). -The column contains data that looks like this: 6129/110 I need to compile...

Hi folks, I'm hoping someone might have a formula for this use case. I have a sheet containing a column of data values. the values are like this: Updated_New_Customer_DE 2016_w32_1_Sunday_ladies [example] I would like to use a formula to extract the value either after the last underscore_ or...

Hi, I'm trying to figure out a way to extract a certain number of letters/numbers from a partucilar cell. For instance if I have the following line: WHCND27364 I want to remove "WHCND27" and remain only with "364", but without using the =Right(X,3) function. Is there a way to obtain...

I have a JSON text result from an API, given below. {"visit":"1","paid":"0","repeatPat":0} I need the numbers to be extracted in 3 separate cells. Please assist.

Hi Everyone! I came across a problem that I need to extract all the text after the second last "/" in a link. For example: "http://www.groupon.be/deals/antwerpen/hotel-kenzi-farah/30596211" I need "hotel-kenzi-farah/30596211". The total number of "/" is not constant, but what is certain is...

<tbody> A 1 10 yr spring 399 rollers 188 sc 40 total 627 ck 2 sc $40 radio board $140 spring $103.80 total $283.80 ck 3 same day 5 yr 299 cables 58 rollers 148 sc 40 545 </tbody> Above are a few samples strings from Microsoft Excel that I need the extraction from, respectively in cells...

extract +/- numbers from alphabet cell %&AmK ! hi sir I'm doing some research, and I have excel sheet attached with 3 columns; cells are complex alphabet (%+-aKM&) with numbers (+-). FOR MY STUDY PURPOSES - i want to extract only the numbers value (be care that some numbers are +; others are...

<colgroup><col><col><col></colgroup><tbody> A 1 TAGS_NAME B TAGS C NAME 2 Holly, Billing Billing Holly 3 Uncategorized Uncategorized 4 James James 5 Uncategorized Uncategorized 6 Existing Service, 7 Holly Existing Service Holly 8 Holly, Walkin Walkin Holly 9 WalkIn...

I've read a few posts trying to solve this problem, but I think mine may be a little different than the ones I have seen so far. And please, by all means, if this has already been answered please guide me. Essentially I have strings of text about 5000+ rows long with names, account numbers and...

Hello guys, I have a column with cells containing html code with various tags, text and various links. Somewhere in these cells there are some hyperlinks of various length from a specific domains The format of the urls are http://www then followed by a random number, then a specific domain and...

Hi, I have a long list of file names and within them sits a five digit sequence of numbers and letters. The problem is, the location of that sequence within the file name, differs for every file. For example: 1) ThisisafilenameAB123.doc - sequence = AB123 2) ThisCD453isafilename.doc - sequence...