Previous Topic Next Topic

Macros Help

Closed
Lilly-FL - Mar 17, 2010 at 01:12 PM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Macro-Copy data from one workbook to another
Krishna -
Dvibe -

12 responses
One Button To Execute Two Macros
azmiismail -
azmiismail -

4 responses
get help Macro sheet
vivekanandan -
ac3mark -

1 response
Help creating a Macro
NanduB -
ac3mark -

1 response