Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-03-2015, 01:26 PM
lbeck lbeck is offline split row of cells at semicolon Windows 7 64bit split row of cells at semicolon Office 2013
Novice
split row of cells at semicolon
 
Join Date: Jun 2015
Posts: 11
lbeck is on a distinguished road
Default


Sorry, I was trying to be concise. The actual application is this. I have a plug-in to Photoshop Lightroom that exports EXIF data for each photograph selected from the library.The data is reported as a.TXT file. I can copy the TXT file and paste it onto an Excel spreadsheet. Problem is that The data is presented as a long string with multiple data sets, Each with identical, repeating fields. What I want to do is to separate that long row into columns.then I would put headings on each column for shutter speed, aperture etc. I was thinking that I could place a character like a ; after each repeating data set and have Excel parse that data from the row and place it into columns. I believe this is possible, but I don't know how to do it.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to split merged data into vertical saperate cells cheekugreat Excel 5 10-11-2014 05:53 AM
Copying text range of cells to different cells adds an extra line jpb103 Word VBA 2 07-23-2014 12:22 PM
Populate Cells with info contained in other cells EC37 Excel Programming 8 07-16-2014 10:55 AM
Losing rows when pasting split cells Gitley Word Tables 1 01-15-2013 07:49 AM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft