subsitute

Hello, I have values that are pulling in from my data set as "Name-Email". I would like to only keep the Name. Is there a formula I can use to get rid of the - Email part?

I need a formula that does substitute ALL "" with "" (including the > character) <*span style..** .><*div style=...* *> <*p style..** .> <**div* *> <*/div* > (I added asteriks and spaces otherwise the tags cannot appear :P Find and replace works for the last 2 but not the others at what...

I require a formula to give me the team name in one cell and the odds in another. Basically separate the letters and numbers. For the odds I require possibly an =right formula to give me everything on the right of the ‘space’ that is furthest right. I’m not sure how to explain getting the name...

Hello, Could anyone suggest how do i Substitue second occurrence of a string within a cell? Cell A1: Port Size","","Female Port Size","1/8" I want to substitute the second occurrence of this "," string with |(pipe). Please suggest me a formula for this. Regards, Raj

Hello, I need to replace various characters, that are located between two special characters. Example: Column A has the following: Sports & Outdoors:Hunting:Knives -- I need to replace anything between the two ":". So, on this line I need to replace ":Hunting:" with ":". I need it to look...