Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-04-2015, 06:50 AM
NoSparks NoSparks is offline split row of cells at semicolon Windows 7 64bit split row of cells at semicolon Office 2010 32bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default


Have a look at this, there's a macro included to take your first row and put it into individual rows starting on row 10.
Alt + F8 will bring up the macro dialogue so you can run it.

I would hope this isn't necessary and that the LR add-in would have some kind of setup that allows the selection of delimiters.
Attached Files
File Type: xls EXIF export example_with_macro.xls (37.5 KB, 13 views)
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 03: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