View Single Post
 
Old 06-03-2015, 09:17 AM
NoSparks NoSparks is offline Windows 7 64bit 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