I have text data opened in excel 2003. Unfortunately, one of the cells has more than 255 characters and the data is being displayed in multiple rows. However, I need some amounts to align in two or three separate columns, but it is hard to do so as the info. for one row gets crossed with the info. from a second row. e.g.
00000000050002300000000000000000000075003500000
00000000000000250000000000000000230059000000000
As you can see above, this data is all appearing in one cell, however, I need the amounts 5000.23 to appear in one column, 7500.35 to appear in another column and then the same with 2500.00 and 2300.59. Completing a text to columns, messes up the numbers I require. Is there a better way of getting this data besides using text to columns?
Please help!!
Bookmarks