Hi friends,

 I have problem with ExcelVB.

 I have following records in an Excel sheet in one cell A only.i.e.,

   A
 1 Jürgen Muster 14,00 81,26 145,67 31.08.2010
 2 Hans Otto 11,00 118,33 188,93 31.08.2010
 3 Sabine Beckmesserin 11,00 60,64 126,00 31.08.2010

 I want these rocords to split in a way to put in an order like

   B C D E F
 1 Jürgen Muster 14,00 81,26 145,67 2010.08.31
 2 Hans Otto 11,00 118,33 188,93 2010.08.31
 3 Sabine Beckmesserin 11,00 60,64 126,00 2010.08.31


 In the column F the date should be Reverse.



 Please mail me some VB source code for Excel.

 Thanks a lot in advance.


 Best regards,






 Reddy.

Maybe this will help you on the way:

1. Copy your column A and paste into a simple txt file.
2. In Excel, open the txt file and follow the wizard.

Try a few options, it will help you get the data split in an easy way.

Probably, your names will be split as well. Merge them again, using a simple Excel formula: insert column, then = A1 & " " & B1.

Greetz