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

Awaiting your valuable result please.

Peranish

"Pecoflyer" wrote:


PERANISH;349025 Wrote:
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

Hi,
I don't understand what you are looking for, but I suppose it's the
SEARCH or FIND function coupled with a search for the string pi* (*
being the wildcard)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97626