Thursday 15 September 2011

excel 2010 - Delete first two characters of an alphnumeric sequence in a column -



excel 2010 - Delete first two characters of an alphnumeric sequence in a column -

i'm trying scan column character size. if alphanumerical character size met (qty 12), first 2 characters deleted. specific numbers (10). see below.

h063088955 f243066424 10g403085387 f253066457 e473057375 g503087343 10h303098124 g093075912 g433084322 10g403085388

select cells wish process , run:

sub qwerty() each r in selection v = r.text if len(v) = 12 r.value = mid(v, 3) end if next r end sub

character excel-2010 alphanumeric

No comments:

Post a Comment