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...
    • BlueFoxx
    • Thread
    • excel formula formula result strip subdirectory deletion
    • Replies: 2
    • Forum: Excel Questions
  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...

Watch MrExcel Video

Learn Excel 2013 - &quot;Chart Legend Changes&quot;: Podcast #1693

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top