Posted to microsoft.public.excel.programming

sylink[_3_] sylink[_3_] is offline

external usenet poster

Posts: 17

Column Split and Extraction

The colum below is named 'REMARK'. I need a macro to extract the
cheque numbers (e.g 100138773) into different column and the names
(e.g KONNY BALL) into another column.

REMARK
========
CHQ 10013873 IFO KONNY BALL
chq10013845 ifo John Bush
chq no 10013848 pd ifo racheal
CHQ#10013928 PD IFO FRANK

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 column and row	Jackie	Excel Discussion (Misc queries)	3	October 16th 08 02:14 PM
How do I split a column?	Wally	Excel Discussion (Misc queries)	1	February 6th 08 09:56 PM
can i somehow put two cells into one column or split a column	Chrono	Excel Discussion (Misc queries)	1	September 5th 05 06:20 PM
How to split column?	Y. Belenky	Excel Programming	2	July 8th 04 06:48 PM
data extraction / cleansing a string column in a workbook	Keith[_12_]	Excel Programming	2	May 3rd 04 08:54 PM

All times are GMT +1. The time now is 06:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us