LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Byron
 
Posts: n/a
Default Importing Comma Seperated Text Please Help ?

Hi There,

I have a device which pumps out text in a "serial stream" the data is in a
format like below:

1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0

Using the text import wizard the data must be arranged into columns or a
table like:

1,2,3,4,5,6,7,8,9,0
1,2,3,4,5,6,7,8,9,0

for it to import into cells, is ther any way I can get the data to format
into cells correctly ?

Anyy help greatly appreciated.

Cheers!

Byron

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import comma delimited text Lin Excel Discussion (Misc queries) 3 July 28th 06 04:07 PM
Paste comma delimited text into a spread sheet Dave Plyer Excel Discussion (Misc queries) 5 June 21st 05 01:39 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
importing multiple text files URGENT!!! HELP tasha Excel Worksheet Functions 0 December 19th 04 04:26 PM
importing multiple text files??? tashayu Excel Discussion (Misc queries) 0 December 19th 04 02:43 PM


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"