Excel VBA / Data Sorting / Maniputaltion

A

Abdul

i have a long list, which i imported from other data base.
The problem is:
1. In each cell, besides data (data is in alphabates) there are som
numeric characters which i dont want .
How can i get rid of all those unwanted numbers from data, from all th
list?

2. The data is in every second row, ie. one row is empty.
How can i Delete those empty/blank rows from the list
 
B

BrianB

Sorry. most of us never open files from the internet.

Just a copy/pasted sample of a couple of records will do - with
headings if appropriate with an example of what result you want.
 
A

Abdul

Here is the sample: by copy paste technique

PROGRAM

50 Minutes - 001F

After News @ 1:00 P.M. - 00I1

After News @ 2:00 pm - 0067

After News @ 3:00 P.M. - 00I2

After News @ 5:00 P.M. - 00I4

After News @ 6:00 P.M. - 00I5

After News @ 7:00 P.M. - 00I6

After News 12:00 PM - 005R

After News 9:00 PM News - 002
 
B

BrianB

Looks pretty straightforward. Assuming your text is in column A you can
copy these formulas down, say,column B.

=LEFT(A1,22) gives you ...... After News @ 1:00 P.M.
=MID(A1,14,4) ..................... 1:00
=RIGHT(A1,4) ..................... 00I2

Look up "Text functions" in Excel help for more info.
 
A

Abdul

I tried your solution but as the Names are different (ie. Characters ar
different) the formula is not working properly.

Second How can i delete every second row?

Again sample data:

After News @ 7:00 P.M. - 00I6

After News 12:00 PM - 005R

After News 9:00 PM News - 002M

After News at 4:00 pm - 0098

Aik Din Geo Kay Saath - 004I

Aik Din Geo Kay Sath Repeat - 0011

Alif - 004M

Alim Online - 001B

Alim Online (Rpt) - 00C9

Alim Online Repeat - 000
 
D

Dave Peterson

PMFJI,

but if those second rows are empty and you want to delete all the rows that are
empty in column A,

you can select column A
Click on Edit|Goto|special|Blanks
Edit|Delete|entire row

If you have some rows that are blank in column A that you want to keep, don't
use this.

=====
Another way:

Select your range
apply Data|filter|autofilter
Filter on that column, but only show the rows you want to delete
(blanks????)
and delete the visible rows.

This is a nice technique, because you could use a helper column of cells with a
formula that evaluates to "delete" or "keep". Then filter on just the deletes
and delete those visible rows.

and that formula could be as complex as you want:

=if(and(a2="xyz,b2>=220,c2<5),"keep","delete")
as an example
 
Top