[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

excel to text without quotation mark

Posted on 2007-04-09
3
Medium Priority
?
585 Views
Last Modified: 2013-11-25
How do I save an excel to text without any quotation marks around each field?
0
Comment
Question by:chekn3
  • 2
3 Comments
 
LVL 45

Accepted Solution

by:
patrickab earned 2000 total points
ID: 18878364
Why not save it to text with quotation marks and then using Word do a Find and Replace " with nothing in the Replace box. That will remove all the quotation marks.
0
 
LVL 11

Expert Comment

by:fanopoe
ID: 18878583
save as type:
Text (MS-DOS) (*.txt)

it's near the bottom of the save as type drop down list.

HTH
0
 
LVL 45

Expert Comment

by:patrickab
ID: 18926558
chekn3 - Thanks for the grade - Patrick
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

834 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