View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PERANISH PERANISH is offline
external usenet poster
 
Posts: 25
Default refer some letter from one cell(pipe/mech or mech/pipe (reqd: pi)

Hai I having text in one column like
Col - A
piping/mech
mech/piping
piping/painting

i need rsult for each row --- pi if Piping No need to refer others.
Awaiting your valuable helps.
Thanks
Peranish