Posted to microsoft.public.excel.worksheet.functions

Martin B

external usenet poster

Posts: 16

Extract part of a text string

Hi
I regularly import data from another program with part numbers identified in coloum A as:
R/RVI/0444
R/RVI/5362
R/VOL/3699 etc.

Is there a way of interogating the full part number and displaying only the middle three letters and the last digits with out the / between

Thanks in anticipation

Martin

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
extract text from string	AskExcel	Excel Worksheet Functions	2	October 9th 07 06:54 AM
How do I extract part of a text string	Brennan	Excel Discussion (Misc queries)	2	November 28th 06 07:26 PM
Extract text string using MID	Turk	Excel Worksheet Functions	5	October 11th 06 06:39 PM
Extract text from String	Dan	Excel Worksheet Functions	8	July 1st 06 12:39 PM
Extract Part of String	[email protected]	Excel Worksheet Functions	1	June 9th 05 08:33 AM

All times are GMT +1. The time now is 04:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us