text and numbers

I have a range. The cells contain a string in them. The string consists of a date (mm/dd/yyyy) and either 1 of two words: Yes or No. Example: <tbody> 07/22/2015 - No </tbody> They are in a single cell, in a single column. Regardless of I need to extract the date preceding the " - " from...

Hi This is the problem. I have a column with something like the following: Column B Line 1 SS 2 d' FS 0 d Line 2 SS 5 d' FF 6 d Line 3 FS 0 d Line 4 FF 0 d' SS 3 d' FS 0 d' FS 0 d' SS 3 d' FF 11 d' And so on each line can be and is different. What I need is all the...

I'm having problems getting the contents of a cell to display where there's text and numbers in the cell. It's a problem that I've never come across before, and I've no idea what the problem is. I have a table with column headings that I need to display in another table. Simply using =K4, L4...

Hello, I hope I can explain my question - I try to solve this problem for a few days and didn't find any solution. I attache the file to make it easier to understand, short explanation of attached file, it have 3 pages: 1. Spots - it contains 2 tables. First table is connected to 2nd one. For...

ok so I'm trying to organize some data but when i paste it from elsewhere i can post it but I can't seem to find a way to organize it. I ave to do hundreds of these and I'd prefer to not do it all by hand so if anyone knows a way of organizing these with a formula that would be marvelous! this...

Hello everyone! I am challenged to write an Excel formula that will conditionally count a combination of text and number values. The best that I can do is to pearl string a long list of Countif formulas. For example: Countif(E12:E32,"3") + Countif(E12:E32,"OT") I wonder if there is a...

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 all, Firstly, I know nothing about excel formulas, I’m trying to return numeric values by selecting “cash” or “card” in a drop down box with this text that would return a value from multiple rows or cells with the return value, This is a cash book spreadsheet with July to June tabs, any...

I am trying to extract numbers, some of which are fractions, from a text string to use in calculating the weight of the material in a list. Example from cell D14: Bar 4x1/4 I was able to extract the "4" with =VALUE(MID(D14,SEARCH(" ",D14,1)+1,(SEARCH("X",D14,1))-(SEARCH(" ",D14,1)+1))) but I...

Hi everyone, I have text data in the single cell in the following format. <tbody> New Advice Requested 242.59 Target Bps, [ Quantity : 3,700, Bps : 0, Target Bps : 242.59 ] </tbody> I would like to extract the 3 data points in the [ ] brackets into adjacent cells if possible. 1...

I'm working on a timesheet, trying to get it to add the various types of leave based on what kind of leave is taken. For the most part, I have this working using the following formula: {=SUM(IF(ISNUMBER(FIND(R$1,C2:P2)),VALUE(LEFT(C2:P2,FIND(R$1,C2:P2)-1)),0))} It is only when there is more...

I am trying to find the last number in a range of cells that include both text and numbers - the range is not fixed and will always change. I know that if I sort the range with the text included it will not truly sort the numbers, so realise that I need to separate the text from the numbers...

Hi All, I am looking for a VBA code for the below issue, Please help. I am stuck where i have to convert the number which are stored as text and i have to convert them in number format and it should not round up the numbers. Below is the sample data for your reference. once data gets convert...

Hi, I apologize if my title did not accurately represent my problem, but the image below illustrates my issue: imgur: the simple image sharer Basically, I am working with a large set of study data, and I need to pare it all down to a single row per study entry. As you can see in the image...

Hi, I’m work in the insurance business and want to be able to keep track of the forms I’ve sent to other companies. Due to different procedures of the companies processing times, the time I have to keep track of the forms differ. What I want is the possibility to have different company names...

I posted a question on here about an hour ago and was informed that a string always equates higher than a number in excel. I tried it out. Cancel date is a range where, if a person has cancelled the date is present, else a "-" exists. So to count the number of people who have not cancelled on a...

Hi all, I'm stuck at the moment with the following problem. I have researching and googling for a solution without luck... Working with vba excel 2010 I have a workbook with two main tabs: PurchaseReport and CeCos_Tab The PurchaseReport contains a range of cells where the first column have...

I have a number of columns which are imported data and include numbers and text in the cells; Eg. <tbody> 5.06 km 10.8 km/h 6.5 km 11 km/h 6.04 km 11.1 km/h </tbody> I want to be able to do things with the numbers like, sum a range, find a range average, find max and min. All of which I...

I have tried many different ways to separate the house number from the street name: =(right) function with 'find' number text to columns replacing 'street' with 'address,' etc so I could separate by the ',' but there is so many variables. Does anybody have an easy way to separate the house...

I am trying to create a line graph using letters and number and I do not want to give the data values and creat a graph from the values. Does anyone know how to do this. For example, I want to be able to plot the following as a line chart. Thank you <tbody> Key Stage 2 End of Y7 End of Y8 End...