mid find len

I need to cut a long column of cells (millions) quickly. The current data displayed in the cell its date and time, displayed in a custom format of dd/mm/yy hh:mm I need to quickly cut this in a new column that only contains the hour. However, the MID function isn't working for this: . I have...

Hi, I'm trying to extract sale order numbers in a certain format but they have recently jumped up in character length so current formula doesn't work for all cells. Current formula is =MID(P2,4,7) This worked fine where number was 0001234567/00100. Now we have numbers such as 0123456789/00100...

Hi, Need help with this formula to show every three letters Ex. Day 1 aaa day 2 bbb day 3 ccc ..... Like it is, it shows Day 1 aaa day 2 aab day 3 abb day 4 bbb etc...

I need excel formulas that will help me differentiate each piece of these cells. Here are examples of the cells Elephant12-8Wb CAT193-45M I already have the formula to get Elephant and CAT on their own. But then I need formulas to get 12 and 193, 8 and 45, and Wb and M on their own. Thank you...

Hi, I need some help with an excel spreadsheet I'm building. I've got a database which shows how much data each employee within the company has on their company mobile phone, but the layout provided from EE is awful, sometimes it might say "8GB Data & Wifi" other times it might say "4gEE Data...

I have list of names in the format of Last Name, First Name Middle Initial. The problem is not every single name has a middle initial and I am looking to make a formula to put the names in First Name Last Name format. Here is the list and the formula I have so far: Extract first name formula...

So I have this problem when importing a csv file, one cell has information that needs to be split into columns or repeated with the same tablet id. I have tried several combinations but everything takes time and it is not clean and it doesnt solve the problem, any ideas data is below and the two...

I have a column with each cell containing text with a reference which I need to extract, the reference is always 10 characters with first 2 being letters (either NL,LT or BE) followed by 5 numbers, followed by a "-" and 2 numbers at the end. The reference is not always in the same position in...

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

I have some bank data, below the reference, can any help in finding the formula that will help get this desired result. From each cell I need cheque number. <tbody> Result Cheque 3791 encashed [Reference : 0-1-4-314-30-Apr-2016] 3791 Transfer Cheque processed: 31102-1447200-8-2-2...

Hi everyone, I have data in "A" column as follow : 00230536UE037; 86473UE023; 004729831HO0471. What i want to do is only to extract the Text from each one of the cells. Simple +Left/+Right will not work due to the variation of the number of characteres within each cell, and positioning of said...

Hi, I am currently trying to import data from a website so that whenever I open up my spreadsheet it automatically updates my data to cut down on some of the time I spend importing each day. I have an imported web query but the data does not populate into tables like it is in the website it...

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

Hi! I'm new to this board and I'm sure this is a very simple solution however I'm stuck right now. I have a column that looks like the below however consistently changes in number of characters and letter. I need to be able to separate the numbers from the letters as they are the unit of...

Hi I am trying to right a code that can read a set of strings that contains numbers and letters and I want to output only the numbers here is what i have Function ExtractNumber(rCell As Range) Dim iCount As Integer Dim i As Integer Dim sText As String Dim lNum As Long For iCount = Len(sText)...

Hi, I know I should be using left/right/mid/find/len, but I am not good at writing those formulas. Hoping someone can help quickly. Data in one columns looks like this: 1X10 GM 1X150 GM 1X8.3 GM 10X24 GM 2X6.2 GM etc... I need to get the total number of grams from here. So I need the output...