Previous Topic Next Topic

Macros Help

Closed
Lilly-FL - 17 Mar 2010 à 13:12
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Mar 2010 à 16:43
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
17 Mar 2010 à 16:43
you can use text to column under Data and used fixed length to split column in two two column

Similar discussions

how to learn macros
lakkakulak -
venkat1926 -

1 response
How to save a copy of an excel sheet using macros?
guido09 -
ac3mark -

3 responses
Macro within Open Office Calc
CMACACKER -
TrowaD -

3 responses
macros to add numbers
Koushik -
vcoolio -

1 response