mid

Hi everyone, I hope you can help me with this. For example: (loop: 123) What color do you like? (loop: 45466) What is your name? (loop: 4114523) How old are you? TO: What color do you like What is your name? How old are you? I like to get ride of the (loop: xxxxx) and have the question...

Hello, I have a large text in one cell (2000 to 5000 characters). There are small sentences in this text each separated by a comma (,). I want to split this text in 1000 characters in each separate cell. I can do that by using Left and Mid function which I did and it works fine but I don't want...

Hello, Can somebody please help me in finding out the answer of the below problem : I have a large text in one cell (2000 to 5000 characters). There are small sentences in this text each separated by a comma (,). I want to split this text in 1000 characters in each separate cell. I can do...

Hello, Can somebody please help me in finding out the answer of the below problem : I have a large text in one cell (2000 to 5000 characters). There are small sentences in this text each separated by a comma (,). I want to split this text in 1000 characters in each separate cell (Example in...

Hello everyone, I am creating an excel database and i need to be able to check if a specific part of a cell (with both start and end guidelines) matches specific test. Right now I have attempted to use the search and mid functions together, but i have not been able to find anything anywhere...

HELP. I am trying to find the right formula to pull out just a document number/serial number out of a string of text. EXAMPLE: Cell A3 Contains: "Refer to WSC.RPP.52-024 for marking requirements." I want to make a formula that will just return "WSC.RPP.52-024". It seems to be tricky...

hello, I needed to do a text based vlookup on two country fields. The issues were that sometimes the countries were not spelt the same in either sheet e.g. in sheet A = Taiwan, sheet B = Taiwan, province of China. I eventually came up with a formula that works but it’s pretty big and...

Hi, I have a column of values in excel that look like this: <tbody> 11065-91 </tbody> I want to add a 0 before the '-' and a 0 in between the final two numbers. I tried to record a macro to figure it out but it didn't work. Any idea how I should do this with VBA? How would you do it for...

I'm strugling with VBA code. I'm quite new at VBA programming. The code below returns an error at line with mid function Scraping from web page works OK (red bold text). I would like to get only part of the text. Sample of data from web page looks like this: firstXXXXsecond Desired result of...

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...

I have a data set in below type in a column. How can I extract & put them into separate columns. <tbody> <tbody> Code:1+Name:Book+Size:200pg+Price:100+Vendor:Abooks </tbody><colgroup><col></colgroup> <strike></strike> <tbody> Code:2+Name:Pen+Size:Standard+Price:10+Vendor:Abooks...

Hi there, I have a many text strings in column A (example: ADA,AGF,AHC,AJB,CLF,LNJ,MRT,NFX,RA4,RC3,RH1,XAC,XB9,XFH,XMF). I want to separate each three digit codes into many separate columns. So starting in column A1 is the string and B1 would be ADA, C1 would be AGF, D1 would be AHC etc...

Hello all! I am trying to come up with a formula to split cells in Column B into 3 separate columns of that respective row. I have in excess of 2000+ rows in Column B with various lengths of the text and I am looking to split this. I've tried all kinds of different formulas using LEFT and MID...

Hi, I am having trouble combining an IF and a mid formula...the mid formula on its own returns the text value I want, but when I use it in an IF formula I am not getting the correct result! Any ideas? The formulas are below for reference... This returns what I want...

I extracted data from and importing it into excel. When I do this the extracted values show up in a cell as shown below. What I want to do is extract the names only into another cell. The names vary in length, characters and spaces. The only constant is the cell text always ends with a state...

Hello, How can I use MID for find a number of characters to the left of where MID starts? It always gives you a number of characters to the right of where is starts! Thank you

Hi Experts, I thought I had this but not able to get it or find a good reference. I have the following, Column D4 and below with currency details i.e. AUD (D4), CAD (D5) etc. Column Z4:Z100 (CurrImport – range) I’m importing data from Google finance but its return format in a cell is “1 SGD...

Greetings, I am trying to sum a range based on a partial middle text criteria in the adjoining range. e.g. in Column A | Column B 6300104 - Beauty | 100 6300105 - is in | 200 6300106 - the | 50 6700104 - eye of | 100 6700106 - the | 75 6800104 - beholder |...

Afternoon all, I have just imported a CSV into Excel 2010 which contains fictional sale data from my friend's online game. The value of the sales has been recorded as a long continuous string of numbers but should read as Gold, Silver and Copper coin currency, for example 10g20s44c. For...

Hello there, I find myself at this, my first Excel forum, for I find myself with nowhere else to turn. Any help offered will incredibly gratefully received. I'm working on a holiday tracker, and it's pretty evolved as it stands. The issue I have two sets of staff on the same page but treated...