Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-03-2015, 09:17 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

This is an interesting question, but I'm not exactly sure what it is.

If the aim is to insert semicolons (or other character) in the raw data from the "suppose I have a program", prior to Excel getting the data, it's probably a question that should be asked of that particular program.

If the aim is to accept the raw data as is and have Excel manipulate it before placement of the data into cells, we would need to have an accurate sample of the data Excel is getting to work with. I emphasize accurate because if the data is now going into separate cells then the 12345 as you indicate would have a delimiting character between the individual digits.
Reply With Quote
 



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 07:34 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