Techies help!
RE: importing non-delimited data into a spreadsheet
I have 169 rows of data (24 items/should be columns) that I need to import into a spreadsheet. The problem is that I got it by opening a .DAT file and it is NOT delimited– not by commas, not by tabs, etc.
Re-entering that data will be a huge pain ( I have two more .DAT files with just as much data)
Aaaagh!!!!Help me please!
Please tell me there is some way to make this work– someway to automate spaces or tabs or commas between those numbers (single digits) so that it will separate out into the spreadsheet columns.
I apologize if my lack of knowledge is apparent in my post…
I’m going to go change my kids diapers, and hope that someone sends me the magic spell while I am gone….
This open post was written 1 year, 8 months ago | V/U/S: 232, 8, 2 | Edit Post | Leave a reply | Report Post
Reciprocity (0) 
Since writing this post fengshuisweetheart may have helped people, but has not within the last 4 days. fengshuisweetheart is a verified member, has been around for 2 years, 2 months and has 24 posts and 1,038 replies to their name.
Replies (8)
Where were you?
You can also watch events on Help.com as they happen
Invite Others to Help
A logged in and verified Help.com member has the ability to setup a Friends List and invite others to help with posts.