| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
refer some letter from one cell(pipe/mech or mech/pipe (reqd: pi)
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
refer some letter from one cell(pipe/mech or mech/pipe (reqd:
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract between Pipe symbol | Excel Discussion (Misc queries) | |||
| Pipe-Delimited CSv File | Excel Discussion (Misc queries) | |||
| Export as pipe separated | Excel Discussion (Misc queries) | |||
| Save excel file with pipe separated | Excel Discussion (Misc queries) | |||
| How can I save Excel am spreadsheet as pipe delimiter? | Excel Discussion (Misc queries) | |||
Linear Mode
