Previous Topic Next Topic

Macros Help

Closed
Lilly-FL - Mar 17, 2010 at 01:12 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 17, 2010 at 04:43 PM
Hello,
I am trying to write a macros that will help me delete the first three characters in a cell. I copy and paste a set of serial numbers into an excel spreadsheet but it always comes up with the numbering before the serial number (see below), and a space. How do i get rid of the number, parenthesis, and space?

1) 2SD934X4MK
2) 2SD934X4RE
3) 2SD934X4RG


Thank you,

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 17, 2010 at 04:43 PM
you can use text to column under Data and used fixed length to split column in two two column
0