text string formula

Hi all, Is there a formula that would return a whole number within a text string? Example in the image of what I'm looking for Note the 'existing text' specific words could change, but each cell should contain only 1 whole number

I have a text string that I need to separate out via formula. I know how to do it via the built in Delimiter, but I have to do this via formula. VBA is an option too .... The sub-strings are delimited by a comma and a space, e.g. ", " The individual sub-strings can range from 2 characters to 3...

Hi there Newby here so not sure how much/little info to post, moderate excel skills, slowly going mad over a project I really please need help with! I have searched this forum and Google with no luck. Heres my problem - I have a XLS with 20,000+ rows and I need to check if words match a table...

Greetings! I have the following text string in cell H in my spreadsheet. I need a formula that can remove the bold part numbers from within the text string. As you can see they are all different sizes. <colgroup><col></colgroup><tbody> Out For Rebuild - Qty:1 / 227-9850 - PUMP GP-AUXILIARY...

I am having an issue extracting data from a column that I have. I need the city of the customer in a new column. The column that I already have is as so: <tbody> US315310 - SENSICAL SOLON OH <tbody> US318310 - DKM-AD ART BUFFALO NY </tbody> </tbody> US500190 - STANDARD RUBBER...

Hi, I'm making an English teacher making quizzes based on lists of sentences with translations. I want to make one formula that takes the text string of another cell and randomly replaces one word with an underscore ____. I'd also like to make a formula that replaces all the words with...

Hey Everyone, I'm sure what I'm thinking of is possible, but I am struggling with using VLOOKUP within a text string. Below in my example I need to compare the test name in column C to the test name in Column A. When a match is found I need it to fill in the corresponding numeric test code...

I'm trying to extract a 4 character string that can be numbers or a text string. Here is the example. Sheet1 <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 126px"> <col style="WIDTH: 64px"></colgroup> <tbody> A B 1 Result 2 abc rtyidf 1034 567...

I want a formula which remove first "*1" from the string and then remove "WH" for the text string. Here is the example and the desired result. <colgroup><col><col></colgroup><tbody> text string Result *1500WH 500 *1 59WH 59 *1305WH 305 *1 1WH 1 </tbody> Thanks, Rashid

Thanks in advance to any/all help! I'd like to remove the last string of numbers (actually costs) from a description -post to a separate column -and then, re-combine with original description leaving off comments... Example: 987654321 6 Snickersbars11/12/14/ DX,T 1.30 .60 3.60 --> desire...

<tbody> Column Data Result NW-Nrth(20% / $2.0M), 0 SW-Rail(0% / $0.M), 0% NW-Calif(5% / 390M), SW-DMA(5% / $39.0M), UGD-UGD W(2 / 179.M), 5% , 0 East-Trans(20% / $80.0M), SW-Rail(20% / $8.0M), 20% TISW-TIC G(40% / $10.0M,SW-Rail(20% / $5.0M) 20% </tbody> I have a column that...