Posted to microsoft.public.excel.misc

external usenet poster

Posts: 3

Text Split

Hi,

I have 4000 line of data which is first and surnames combined e.g DavidHill,
MarkSmith etc etc. I need a formula to divide these by the second capital
letter only to make David Hill, Mark Smith etc etc

All entries have a capital letter at the start of the forename and surname,

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
How to split up text	Hilton	Excel Worksheet Functions	5	July 10th 08 11:50 AM
Split a text	Manos	Excel Worksheet Functions	7	October 17th 07 05:51 PM
Split text without using data-text to columns	Jambruins	Excel Discussion (Misc queries)	7	January 21st 06 02:16 PM
Split Text	Gabe	Excel Discussion (Misc queries)	6	January 4th 06 09:52 PM
text cells end page how split to next. Text lost!	Elaine	Excel Discussion (Misc queries)	1	August 28th 05 05:48 PM

All times are GMT +1. The time now is 11:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us