Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How to remove excess / in excel? (https://www.askmehelpdesk.com/showthread.php?t=643498)

  • Mar 14, 2012, 11:07 AM
    joeysison
    How to remove excess / in excel?
    /baf usd 0/caf 10.51 % of bas,ers,opa,pss,stt//////ddf eur 30/dhc eur 195////////////opa usd 50////psi eur 5/pss usd 0/ser usd 9//

    To become

    Baf usd 0/caf 10.51 % of bas,ers,opa,pss,stt/ddf eur 30/dhc eur 195/opa usd 50/psi eur 5/pss usd 0/ser usd 9
  • Mar 14, 2012, 11:39 PM
    JBeaucaire
    If that string were in A1, then in B1:

    =MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"////", "/"),"///", "/"),"//", "/"), 2, LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"////", "/"),"///", "/"),"//", "/"))-2)

    • All times are GMT -7. The time now is 01:08 PM.