delete text to the left of,,,,,,

  • Thread starter Thread starter Sheila
  • Start date Start date
S

Sheila

Hi

I have about 8000 rows of text in an excel sheet that I want to delete
all the text to the left of the "/" (without the quotes of course).
Can anyone help me with a simple formula for that so I can create a
list next to the existing one without such text?

TIA

sheila
 
One way:

B1: =MID(A1,FIND("/",A1)+1,32766)

if not all cells have the "/":

B1: =MID(A1,IF(ISERR(FIND("/",A1)),1,FIND("/",A1)+1),32766)
 
How do I delete text to the right, and leave all to the left including
the first position in the cell???

Whobe
 
Whobe, try this:

=LEFT(A2,FIND("/",A2)-1)

Whobe said:
How do I delete text to the right, and leave all to the left including
the first position in the cell???

Whobe
Click to expand...
 
Back
Top