Posted to microsoft.public.excel.misc

Tony S.[_2_] Tony S.[_2_] is offline

external usenet poster

Posts: 60

Extract between Pipe symbol

Can someone please tell me if it is possible to write a formula that would
extract all the text that exists between the vertical bar symbol "|".

Example in the following Cell A1 contains:
W213FR|BADC12GW34-14|SPACER, DEG

I want to extract only "BADC12GW34-14" and put it in another cell, say B1.
Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pipe-Delimited CSv File	stevieb	Excel Discussion (Misc queries)	3	August 7th 08 08:08 PM
Export as pipe separated	Sashi[_2_]	Excel Discussion (Misc queries)	2	June 20th 07 04:46 PM
Save excel file with pipe separated	Vijay Kotian	Excel Discussion (Misc queries)	5	November 3rd 06 06:21 PM
Extract Symbol	Karen	Excel Worksheet Functions	9	October 24th 06 04:20 PM
How can I save Excel am spreadsheet as pipe delimiter?	Sarah	Excel Discussion (Misc queries)	5	May 25th 06 08:36 PM

All times are GMT +1. The time now is 10:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us