If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Saving Excel as TXT without tab delimiter

padair · 2009-04-03 13:53:07

Hi there, I am having problems trying to save an excel spreadsheet as text without tab or space delimiting. Does anyone know how to do this. I have been playing around with the setting and saving as Text MSdos but to no avail. All help muchly appreciated. P.

Options

03-04-2009 2:53pm

#1

padair

Registered Users Posts: 1,318 ✭✭✭

Join Date: May 2008

Posts: 1212

Hi there,
I am having problems trying to save an excel spreadsheet as text without tab or space delimiting. Does anyone know how to do this. I have been playing around with the setting and saving as Text MSdos but to no avail.
All help muchly appreciated.
P.

0

Comments

Options
#2 03-04-2009 4:08pm
TinCool

Registered Users Posts: 2,894 ✭✭✭

Join Date: February 1998

Posts: 2591

I don't think it's possible to save an EXCEL Spreadsheet in plain text without some kind of delimiter. To be fair, what use would a lot of columner data be without it being delimited in some form. You'd end up with one long string.

0
Options
#3 03-04-2009 4:44pm
stevenmu

Moderators, Society & Culture Moderators Posts: 9,689 Mod ✭✭✭✭

Join Date: July 2003

Posts: 9396

You could export as say a comma delimited file, and then open it in notepad and use replace to replace all commas with nothing, or a single space or something like that.

0