Macros Help

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use text to column under Data and used fixed length to split column in two two column
0