How do I delete everything after a / in a column?
The first half of my cell is unneccesary, then comes a slash ( / )
and I need everything after that
Your Subject says the opposite of your message. I'll assume your message is
accurate. Assuming A1 is the cell containing your text...
=MID(A8,1+IF(ISERR(FIND("/",A8)),"0",FIND("/",A8)),1024)
The above formula assumes there will only be a maximum of one slash
character. If there is more than one, all characters after the first one
will be returned. (If there is no slash character, the entire text will be
returned.)
Rick
|