how to separate text and numeric data in the excel or text file.

Posted to microsoft.public.excel.programming

lonkar

external usenet poster

Posts: 1

how to separate text and numeric data in the excel or text file.

i have a file which content the text data followed by numeric data after
every 35 to 40 lines.
data and text is different.file lenth is of 7000 rows.such 2000 files r to
be cleaned.
i need urgent solution to this.
pl help.
send email on

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 text file into Excel sheet and separate the final results intoa new sheet	Luciano Paulino da Silva	Excel Worksheet Functions	8	April 18th 09 02:00 AM
Querytables.add with sql query text stored in separate text file	StuartBisset	Excel Programming	5	March 18th 09 12:07 PM
I open a CSV file with excel, but the text is separate with comma!	August	Excel Discussion (Misc queries)	3	March 22nd 07 11:02 AM
Ascii iinput file - separate text from Numbers	[email protected]	Excel Worksheet Functions	3	August 29th 06 02:46 PM
Can I use Excel to match text data from 2 separate columns ?	Dan	Excel Worksheet Functions	1	September 29th 05 03:51 AM

All times are GMT +1. The time now is 01:41 PM.

Menu

About Us