Posted to microsoft.public.excel.worksheet.functions

AskExcel

external usenet poster

Posts: 19

extract text from string

hi,
i have string as below. i need to extract 4 letter after the ','. the 4
letter is ABCD,AEGR,RTYT and TYRE.
may i know how to extract?
thanks

d123,00ABCD9657
d1005,12AEGR8678
d23,23RTYT6545
w345676,23TYRE7786

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
How to extract text from middle of a string	Makelei	Excel Worksheet Functions	18	July 9th 08 09:03 PM
Extract text from a string	ellebelle	Excel Worksheet Functions	4	June 13th 07 04:25 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 % from text string	Mike	Excel Worksheet Functions	5	December 1st 04 08:02 PM

All times are GMT +1. The time now is 06:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us