Jasa P
Board Regular
- Joined
- Feb 6, 2012
- Messages
- 68
Hi, I'm looking for VBA code that can save the function of Text to Columns. So, if I open a workbook and paste the combination below, I don't need to separate them manually using Text to Column. This combination will be separate in few columns automatically after I pasted them in workbook.
M01=09#214.218x20.50/81x50/23.49.78x20 in Cell A1
so in cell
B1 --> M01
C1 --> 09
D1 --> 214.218x20.50/81x50/23.49.78x20
The numbers are not always the same, can be more complicated than this.
I'm using Excel 2007
Any help would be great
Regards
Jasa
M01=09#214.218x20.50/81x50/23.49.78x20 in Cell A1
so in cell
B1 --> M01
C1 --> 09
D1 --> 214.218x20.50/81x50/23.49.78x20
The numbers are not always the same, can be more complicated than this.
I'm using Excel 2007
Any help would be great

Regards
Jasa
Last edited: