strip

  1. A

    Stripping out data

    I have and column that reads this "8.50 (13.0)". I would like to strip out the data into 2 columns and remove the parenthesis from the second one.
  2. K

    Excel formula with 03 sub qty

    <tbody> A B C D E F G H I J K L M N O P Q R S 1 SR. PRODUCT BAG PKT STRIP PCS QTY1 QTY2 QTY3 QTY4 QTY5 TOTAL QTY BAG PCS PKT IN BAG STRIP IN PKT PCS IN STRIP 2 1 MD 19 PKT 3 STRIP 8 PCS 380 240 150 20 8 798 960 24 4 10 3 2 FR 2 BAG...
  3. K

    Excel formula with 03 sub qty

    1 BOX = 600 PCS 1 BOX = 15 PKT 1 PKT = 4 STRIP 1 PKT = 40 PCS i.e. A=290 PCS B=100 PCS C=350 PCS D=132 PCS E= 460 PCS F= (A+B+C+D+E) = 1332 PCS NOW I WANT CONVORT THIS QTY IN BOX/PKT/STRIP/PCS i.e G= BOX H= PKT I= STRIP J= PCS I WISH TO GET RESULT LIKE BELLOW G=2BOX H=3 PKT I=1 STRIP...
  4. B

    How to strip subdirectories out of URL's

    Hi there, I've been searching for solutions to delete / strip a section in a URL that is a subdirectory. So for example: https://www.domain.com/directory1/directory2/url-remaning.html needs to become https://www.domain.com/url-remaining.html. I've been reading these posts...
  5. J

    VBA Web strip problem

    My employer asked me to strip https://www.citb.co.uk/cards-testing/online-card-checker/ to check all employees of valid constitution cards. All code is working fine but at some point after number of "For each" my VBA returns error. It turns out that cookie notification go at front of the web...
  6. E

    strip string from both sides

    Hello people I got this string "2015-07-22" but I just want to have "07" Could someone help me with a code? Thank you in advance
  7. S

    Use a Strip and if else in spreadsheet to determine average.

    Hi I want to complete this style of logic in Excel but am not sure how. \\ values in a table B2:M2, they will contain either 3 types of values M100, H100 or NA. After M there may be any different number result between 0 and 100. So (M80, M82, M64 are valid). H stands for Home and M stands for...
  8. C

    Remove Last 2 Characters from Cell

    We have customer address info setup with the city and state combined into one, the state abbreviation being the last two characters. I would like to remove the last two characters to get just the city name. I cannot use text to columns with space as a delimiter as some of the city names have...
  9. L

    Stipping a character out of values

    I have a sheet that contains dashes (-) in the numbers in on particular column. I need to get rid of the dashes but there is no consistency to where they are located. Is there a formula that will simply strip the character out regardless of where it is located in the field? For example...

Some videos you may like

This Week's Hot Topics

Top