Posted to microsoft.public.excel.worksheet.functions
|
|
How do I delete everything after a / in a column?
Another way
=MID(A8,FIND("/",A8&"/")+1,1024)
--
Regards,
Peo Sjoblom
"Rick Rothstein (MVP - VB)" wrote in
message ...
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
|