refer some letter from one cell(pipe/mech or mech/pipe (reqd: pi)

  • Thread starter Thread starter PERANISH
  • Start date Start date
P

PERANISH

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
 
I want formula for getiing letters "pi" if cell contains "piping"

Awaiting your valuable result please.

Peranish
 
I want formula for getiing letters "pi" if cell contains "piping"

Awaiting your valuable result please.

Peranish
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=IF(ISNUMBER(SEARCH("ELB", and more than one text 2
Combine multiple cells into one cell. 3
Copy Headings based on Cell Value 2
Convert code to lookup three criteria return fourth 15
To criteria with Reference from Cell 3
Formula to Identify Col Data-Pairs that Differ by 2*pi 2
a data validation list that contains a list of named ranges - not alist from a named range 1
Match and delete rows on two different sheets from reference numbers 4

Back
Top