Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

external usenet poster

Posts: 137

Split Field content in Query?

Hi All,

Is it possible to get part of data in a field using query?

I have a filed for which the number of characters is not fixed containg
data in the format xxxx/xxxxxxx

I want to get only the right side of the "/" only in a field. The
number of characters after "/" is not fixed.

Any help please?

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
split the content of cell	cosmic	Excel Worksheet Functions	3	May 28th 10 04:48 PM
Split cell content	PK	Excel Discussion (Misc queries)	3	March 5th 10 08:36 PM
Split One Work book into several based on content	Rich	Excel Worksheet Functions	2	May 21st 06 06:24 PM
split cell content	Ove[_2_]	Excel Programming	1	September 21st 04 02:23 PM
split cell content	portroe	Excel Programming	2	February 11th 04 08:11 PM

All times are GMT +1. The time now is 10:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us