text string formula

  1. P

    Help with a formula search for text in a cell from a lookup table

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

    Remove part number from a text string

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

    Text String Variable Length

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

    Formula to Replace Words in a Cell

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

    VLOOKUP using text

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

    Extract 4 character string

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

    remove characters from text string

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

    Help extracting string - 3 spaces from end of description

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

    Find a value in a string specific to a text

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top