Excel Text To Columns - default "column data format" to Text

Posted on 2013-01-30
Last Modified: 2013-02-01
In Excel Tex To Columns can I set the default "column data format" to Text?
Question by:Dawn7930
  • 5
LVL 26

Expert Comment

ID: 38836325
Hi, Dawn7930.

AFAIK, the only "sticky" values are those on the Delimiter page.

Would a macro help?


Author Comment

ID: 38836349
Can I set it up as a PrivateSub to run on open?
LVL 26

Accepted Solution

redmondb earned 500 total points
ID: 38836572

Yes, as long as it's in the same module as your Auto_Open or Workbook_Open macros and is called by whichever of them you're using.

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

LVL 26

Expert Comment

ID: 38837371

This is a tricky issue, but unlike the rest of the English-speaking world, in Experts Exchange, "Good" means..."Not Good". To quote from one of the Help pages...
An A grade should be given if you receive the solution from the Experts; you should consider the A grade the default unless it is deficient.
It is customary to explain any grade that is not an A.

You could reasonably say that I didn't give you a solution. However if something can't be done, then "it can't be done" is a perfectly valid answer and is not grounds, by itself, for a B Grade. (The logic is that the expert has given you the correct answer and it's not fair to penalise him/her for a restriction in Excel, or whatever.)

Please do one of the following...
 - If you genuinely feel that my answers were deficient then please explain why.
 - If all the above was new to you (it is well concealed in the site) and you want to give me an A grade then please click on the Request Attention button above and ask for one of the Mod's to change the Grade. (He/she may simply "unclose" the question so you can do it yourself.)
 - If you would like clarification/confirmation of what I've said then click on the Request Attention and ask for a Mod's assistance.

I'm sorry to be such a nuisance, but B's and C's are considered to be blots on an expert's record so it's important that they're only there for valid reasons.

Many Thanks,
LVL 26

Expert Comment

ID: 38842233
Thanks, ModeIT.
LVL 26

Expert Comment

ID: 38845021
Thanks, Dawn7930.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question