Macro......
That word scares me. I'm not an Excel expert and have never written a macro of any sort. But I have worked with most of the Excel menu functions over the years. I seem to remember cut/pasting text into a spreadsheet and a wizard appearing asking if I wanted the cells to be parsed at a character like a comma or semicolon, or whether I wanted fixed width (vertical lines appearing in the wizard) columns.
That's kind of what I was hoping. For example "Go to menu/Insert (or data, whatever)/a/b/c" to find how to split the horizontal row of text to split it at designated points and move the groupings into columns.
I'm still not convinced that there isn't a way for Excel to do the work without my need to write a unique macro. Maybe I'm wrong, but I'll keep trying.
Just for fun, I've pasted one set of exported data groups below with semicolons inserted at the desired break points. This can be bulk copied and pasted into cell A:1 and a long string appears. The original text had many spaces between data entries like the export expected data to be parsed from the string. my preview of this post shows that white space removed. I can of course cut the text groups from the string and align them into columns manually, but that would be more work than my objectives can tolerate.
I'm not trying to get you to do the work for me, only to give the best example. Once I get this figured out, I plan to export literally thousands of individual pieces of information to construct a database of information that I then can search and sort in Excel.
20060814-100_3700132920.JPG 1/500 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA Microsoft Photo Gallery 16.4.3528.331 ;20060814-3702 enhanced132950.JPG 1/500 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA Microsoft Photo Gallery 16.4.3528.331 ;20060814-100_3704 (2)133014.jpg 1/750 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA Microsoft Photo Gallery 16.4.3528.331 ;20060814-100_3704133014.JPG 1/750 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA ;20060814-100_3705133045.JPG 1/500 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA Microsoft Photo Gallery 16.4.3528.331 ;20060814-100_3707134901.JPG 1/500 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA ;20060814-100_3717140231.JPG 1/500 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA ;20060814-100_3733 Edited by Andy155547.jpg 1/1000 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA Adobe Photoshop Lightroom 5.7 (Windows) ;20060814-100_3733155547.JPG 1/1000 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA Microsoft Photo Gallery 16.4.3528.331 ;20060814-100_3733 Edited by Lee155547.jpg 1/1000 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA Microsoft Photo Gallery 16.4.3528.331 ;20060816-Waterfall Cascades135737.jpg 1/500 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA ;20060816-Snow-covered Mountains - cloned140319.jpg 1/750 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA ;20060816-Snow-covered Mountains140319.jpg 1/750 ISO 100 KODAK DX7630 ZOOM DIGITAL CAMERA ;20060822-Panorama at Lak Louise (2)154143.jpg Microsoft Photo Gallery 16.4.3528.331 ;20060822-Panorama at Lak Louise154143.jpg ;20060822-Pan-Emerald Lake155414.jpg ;20060822-Pan-Gondola191518.jpg ;IMG_0002.JPG 3.94 1/40 ISO 64 iPhone 5c Microsoft Windows Live Photo Gallery 15.4.3555.308 ;IMG_0004.JPG ;IMG_0008.JPG 6.08 1/120 ISO 50 iPhone 5c Microsoft Windows Live Photo Gallery 15.4.3555.308 ;IMG_0009.JPG 6.58 1/150 ISO 50 iPhone 5c Microsoft Windows Live Photo Gallery 15.4.3555.308 ;IMG_0010.JPG 6.74 1/150 ISO 50 iPhone 5c Microsoft Windows Live Photo Gallery 15.4.3555.308 ;IMG_0011.JPG 4.97 1/120 ISO 80 iPhone 5c Microsoft Windows Live Photo Gallery 15.4.3555.308 ;
|