Ask Experts Questions for FREE Help !
Ask
    joeysison's Avatar
    joeysison Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Mar 14, 2012, 11:07 AM
    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
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Mar 14, 2012, 11:39 PM
    If that string were in A1, then in B1:

    =MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"////", "/"),"///", "/"),"//", "/"), 2, LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"////", "/"),"///", "/"),"//", "/"))-2)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Remove a certain charcter from excel [ 14 Answers ]

I need to delete the first (-) for example 101-1-7 need to change to 1011-7

Remove , in excel sheet [ 1 Answers ]

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Why there's an excess? [ 5 Answers ]

You liked some shirt that costs $97. You borrowed $50 from your mom and $50 to your dad. How much you got? $100. You bought the $97 shirt, how much is the change? $3 You returned the change ($1 for mom & $1 for dad), how much is left with you? $1

How to remove a character using Excel function [ 3 Answers ]

Could anyone know if there is any Excel function that I can use to remove a certain character from a text string, e.g. 1). Remove space from "acurve is what" 2). Remove "-" from "acurve-is-what" 3). Remove "'" from "acurve'is" And so on. Thanks a lot!

View more questions Search