Cells formating

[Boris7265]

Hello all of you .

I have a problem in a Excel file that I import from Access.The file in the big (10000-15000 rows) and numeric datas in colum A and B have import with "*" .I would like to create a macro that remove all "*" and other sings that are not number from coulm A and B and leave only numbers in there.
Thank you for your help.

 

[Tom Urtis]

Are you sure you need a macro? If you select the column of data, then press Ctrl+H and in the Find what field enter ~* you can click Replace all and the asterisks * will be gone. The VBA code line for that if for example you want to get rid of those charactars in columns A, B, and C

Columns("A:C").Replace What:="~*", Replacement:="", LookAt:=xlPart

 

[Boris7265]

Thank you very much for your help