Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel spreadsheet HELPPPPPP


  • Please log in to reply

#1
Octrickesirk

Octrickesirk

    New Member

  • Member
  • Pip
  • 3 posts
How the heck do you change an excel spreadsheet into a delimited text file?????
  • 0

Advertisements


#2
greyknight17

greyknight17

    Malware Expert

  • Visiting Consultant
  • 16,560 posts
Welcome to GTG.

Can you give us more details? What exactly are you trying to do here? Split text up?
  • 0

#3
Octrickesirk

Octrickesirk

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
I'm actually trying to change my excel spreadsheet into a delimited text file to import this spreadsheet into a program called ACT!. Thanks.....
  • 0

#4
greyknight17

greyknight17

    Malware Expert

  • Visiting Consultant
  • 16,560 posts
OK, so you want to separate the data you have in Excel now into delimited text? Could you give me a sample (change any data if you don't want me to know the actual data) for a few of these data fields and how you want them to be changed? Give me a before and after example so I can have a clearer idea of what you have now.
  • 0

#5
Octrickesirk

Octrickesirk

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
Honestly I don't even know. I have a spreadsheet with about 22 columns including, name, address, phone number, social security numbers, etc etc. Basically it's for loans. I work with my brother in a loan office and I need these fields i.e name address etc etc put into delimited text so they can be implimented into the fields of the program ACT and i set up ACT with the same fields as name, address, phone number etc etc. ACT only will import delimited text files and this spreadsheet is not .txt. I hope that helps. If you need more info let me know again. I'm sorry it's kinda hard to explain.
  • 0

#6
greyknight17

greyknight17

    Malware Expert

  • Visiting Consultant
  • 16,560 posts
OK, so basically they are not delimited at all now?

I just took a look and see that Excel has an option to save it as a delimited text file. Try it out yourself. Backup this copy and try saving it as delimited text. It's under Save As Type -> Text (Tab delimited)(*.txt).

Do you have to use commas as delimiters or are the tabs like above ok?
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP