Posted to microsoft.public.excel.programming

Max Bialystock[_2_] Max Bialystock[_2_] is offline

external usenet poster

Posts: 31

separate two strings

A cell contains an author's name and a book title separated by a colon.

Charles Dickens : Great Expectations

I need to get "Charles Dickens" into sAuthor

and "Great Expectations" into sTitle.

In this case there is always a space before and after the colon.

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
separate strings	cz1	Excel Discussion (Misc queries)	2	October 29th 09 10:07 PM
how do i separate 2 strings of a cell in different cells?	Bona	Excel Worksheet Functions	1	July 26th 07 11:32 AM
Comparing character strings in separate cells	Odin[_2_]	Excel Programming	6	October 13th 06 08:36 AM
Break up strings into separate cells	al007	Excel Programming	4	November 23rd 05 11:14 PM
Match data of two identical strings in two separate spreadhseets	Mahendra	Excel Discussion (Misc queries)	0	September 14th 05 11:40 PM

All times are GMT +1. The time now is 12:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us