Free Microsoft Excel 2013 Quick Reference

Excel Quotation Marks!

If I save (using a macro) an excel file as a text file MSDOS (not tab
delimited), I get a file with quotation marks at the start and end of each
line! If I do the process manually the file is perfect. Can someone help !!

Excel 2000 all updates done
XP prof all updates done (with sp2)

Thanks


Post your answer or comment

comments powered by Disqus
I have an Excel 2003 SP2 file with columns that contain text that includes
double quotation marks. For example: Select "Yes" to process this form.

When I save the file as a CSV file, the double quotation marks are saved.
However, when I ftp the file to a Unix server, the double quotation marks are
removed from the file.

So....how can I preserve the double quotaion marks in the file when I ftp it
to a Unix server? The only soltuion I have found is to replace each double
quotation mark with 2 single quote marks prior to ftping it, then replacing
the 2 single quote marks with a double quotation mark on the Unix server
after ftping it.

Thanks for your help!
Shannon

Need to import .csv files into a application with quotes around the values in
a field.
Excel is stripping off quotation marks from .csv files if the field contains
a number.
Have a .csv file that is exported. Each field is comma separated and has
quotation marks around the value in the field. Example

"Jerry","Smith","10 10th Street","New City", 'New State" ,"97744"

If I open the file in Excel it removes the quotes from 10 10th Stree and
97744 and I cannot import them. Is there a setting or .vbs script I can run
to make sure all the fields have quotation marks?

when i copy cells from excel into another application (html form, txt editor, dreamweaver) excel adds quotation marks.

example:
cell in excel:
="<h3>"&D2&"</h3>
<a href='"&T2&"'><img src='"&R2&"'/></a>"
&V2&"</div><br />
<div class='modet'><span>"&AB2&" </span>| <a href='"&"/cat/"&K2&"/'>"&J2&"</a> | <a href='"&T2&"'>no reply</a>"

when i copy the whole cell into another application i get:
"<h3>test101</h3>
<a href='medana/'><img src='/content/'/></a>just some text</div><br />
<div class='modet'><span>18 November, 2007 </span>| <a href='/cat/'>some text</a> | <a href='/kria/'>no reply</a>"

how can i get rid of these quotation marks?
can i change excels "copy options" to avoid it?

thanks

Hi,

Excel is adding quotation marks to my my data when saving as a tab delimited text file.
I know (after some googling) that you can overcome this by using the 'PRINT' command instead of 'WRITE', but I'm not doing any VB coding so it doesn't seem to apply in my case and I wouldn't know how to do it if it did.

I'm simply manually selecting 'Save As' and creating the file that way.

Does anyone have any suggestions please? Thx

[EDIT]Solved Well....Kind of. What I've learned since making my post may help others, so I came back with a bit of an update.

For some reason, it took a while to occur to me that I could just copy and paste my desired selection into a blank text file instead; I think I assumed ti would lose the formatting, but of course it doesn't.

Anyway, I've done that now and it works fine. I can live with this for now, but since the whole point of my Excel tool is to help me automate my workflow, it kinda defeats the purpose.

So I'm still keen to learn how I can stop Excel adding the quotation marks when exporting.

During my search, I came across this: http://www.asap-utilities.com/index.php

It's an action-packed Excel utility suite that integrates seamlessly with Excel and has 300 macros and other functions. It's free for personal use and a reasonable price for commercial use. Definitely worth checking out.

I was eager to try this out to see if the files it exported contained the quotation marks and sadly, they do, so there's obviously still something I need to do with Excel to stand any chance of avoiding them.

Any leads?

p.s.
Hope I didn't break any forum rules with the link I posted. I'm sure it's probably a well-known product in this forum, which may or may not have some history here, good or bad. I wouldn't know, since I'm new to all this, but I felt it was worth mentioning.

We have a SAS report that generates a CSV and sends it out to users every monday. Every user that has Excel 2003 has no problem opening the file and viewing it correctly, however the ones with excel XP that open it and save it, it seems the XP version is putting quotation marks around every record. This causes it to A) display incorrectly in other versions of excel and B) get rejected by the 3rd party system for which these files are intended. Why is Excel XP modifying these files and how can we fix or put a stop to it??

Hi, I'm using a query that dumps information into Excel. The query automatically creates a formula in each each cell. For instance if the first value in the query showed FUNSTUFF, after dumping it into Excel, the contents of the cell would show ="FUNSTUFF"
I can just use a find and replace to get rid of the leading =", but sometimes the values of the cells are supposed to have a quotation mark, so using the same method to remove the trailing quote won't work. I need a way to search each cell, check if the last character in the string is a quote, and if it is, delete it. Thanks in advance for any help!

I'm trying to save an Excel spreadsheet created with VBA as a text file within the code, but I am running into problems with nested quotations. Currently, my code looks like this:


	VB:
	
" 
 
Sheets("Sheet2").Cells(Cell,1) = Filename 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
When this is saved in the excel cell it looks exactly as needed with quotes around the file path and one, but when I use SaveAs to put this into a txet file all of the quotation marks show up. I need to have this line show up as:


in the text file so that it may be used in another program.

Any help would be greatly apprieciated,

Thanx,
Whitney

I have a very long list of names/affiliations in Excel 2003 file that I want to use to create labels on a Dymo Labelwriter. The Labelwriter software has a "paste and print" function -- you can copy from one application and paste directly into the tray icon. You don't create a single file with all the names -- it essentially just overwrites the last entry with the next one. This is handy at an event when checking in people -- find their names, print a label.

This works fine on cells where there is a single line of text, but where the there are two lines -- and apparently alt-ent was used to enter a hard return -- the text pastes with quotation marks at beginning and end.

This will be cumbersome to deal on-site, where someone would have to go into each label and remove the quotation marks before printing. Is there some better way to deal with this?

Hi, I need to save my file which contains a column that contains a number
with quotation marks. My attempts so far at saving a comma delimited file
produces 3 quotation marks intsead of my original 1 on each side of the
number. In excel it appears as "5123" but after I save to comma delimited
it appears as """5123""". Any thoughts on how to save just the single
quotations?

Hi, I've currently got this problem at work - any help would be
appreciated.

I've exported a CSV file of payer information from one of our systems
with the plan of being able to manipulate this data and import back. It
only allows the choice of saving it as a txt file which i do. When I
open this in notepad the charactors appear somewhat like this (I'm
going from memory here):

, "0027892", "Mr & Mrs Bloggs", 0, 1, 1

I then started excel and opened the txt file with the use of import
wizard making sure I converted some of the columns to text so I didn't
remove the leading zeros.

I then tried to save this in excel as a csv file. However, a message
came up saying that part of the format was uncompatable but did I want
to save anyway,this I did.

Problem is whenever I save it as a txt file again with this aim of
importing the amended data, the leading comma and all the quotation
marks are gone. It appears something like this in notepad:

0027892, Mr & Mrs Bloggs, 0, 1, 1

Any ideas as to what I'm not doing correctly?

Sorry about the longwinded post.

Matt

--
rammstein
------------------------------------------------------------------------
rammstein's Profile: http://www.excelforum.com/member.php...o&userid=31869
View this thread: http://www.excelforum.com/showthread...hreadid=516001

I have an excel doc, I save it as a .csv and then open the excel doc using
word pad
some of the text should include quotation marks but they are not there.
It does work using access though.
Any suggestions as how to get the quotation marks to show up.

Thank you
--
9pluck9

I'm building tiresome SQL statements by concatenating text and cell contents.
I need to be able to insert double quotation marks into the actual text
strings for concatenation. Excel won't allow this because to concatenate the
strings themselves, they must be enclosed in double quotation marks.

Example: =CONCATENATE("extvalue"&C1174&" "&D1174&",") gives me "extvalue211
Legal Name," when what I actually want is "extvalue211 "Legal Name"". (And
no, I don't want to rename all my SQL column headers to contain underscores
and no spaces!)

Typed single quotation mark ' in cell, and it doesn't show up on sheet. I
remembered that I needed to type two single quotes to have one show up in
cell, but I don't remember why. Can someone refresh my memory please. Thank
you!

When in Excel and I try to enter a single of double quotation mart nothing
happens, and when I try again I get two single or double quotation marks.

I think it has someting to do with the keyboard settings

I have a fixed width data file and need to convert it to a csv file with
quotation marks and commas a delimiters. I thought there was an easy way to
do this in Excel. I open the file with excel and I can define fields but I
cant figure out a way to save the data with quotation marks around the files
separated by commas. Is there any easy way to do this. I have 8 files to
do this with containing about 20-25K records each.

Thanks

When I use the Substitute function on a text string, and then save as a Tab
Delimited File, I get Quotations Marks at the beginnig and end of the cell
results. I don't want them.

They don't appear in Excel, but they are in the resulting file.

I export EXCEL file to CSV at EXCEL XP Chinese versions. If the cell content
is Ā”Ā°filed_nameĀ”Ā±, at CSV file change to Ā”Ā°Ā”Ā±Ā”Ā°filed_nameĀ”Ā±Ā”Ā±Ā”Ā±, both sides
have excrescent double quotation marks. If the cell content is filed_name,
at CSV file same no any marks.

How can export to CSV no excrescent double quotation marks?

My manager has a work sheet with strings like pol_ID, quantity, extact_dt.
He wants to force excel to put quotations around any strings so that when he saves the .xls as a .csv and then opens the file in notepad, the quotation marks will be there.

So what he wants is "pol_ID", "quantity", "extact_dt"

Does anyone know if this is possible, and how to accomplish it?

Thanks

Hello,

I have been converting excel files to .txt format. I initially save my file in .xls, then proceed by saving it a second time with a .csv format. Finally, I go to the file and change its convention from XName.csv to XName.txt manually. The file becomes a notepad file.

The problem arises when one of my cells is a single quotation mark ("). Somehow excel fixes or converts it to four quotation marks (""""). I need just one. Please let me know of a way in which I could make this happen.

Thanks!

Hi, I need to save my file which contains a column that contains a number
with quotation marks. My attempts so far at saving a comma delimited file
produces 3 quotation marks intsead of my original 1 on each side of the
number. In excel it appears as "5123" but after I save to comma delimited
it appears as """5123""". Any thoughts on how to save just the single
quotations?

Hi, I've currently got this problem at work - any help would be appreciated.

I've exported a CSV file of payer information from one of our systems with the plan of being able to manipulate this data and import back. It only allows the choice of saving it as a txt file which i do. When I open this in notepad the charactors appear somewhat like this (I'm going from memory here):

, "0027892", "Mr & Mrs Bloggs", 0, 1, 1

I then started excel and opened the txt file with the use of import wizard making sure I converted some of the columns to text so I didn't remove the leading zeros.

I then tried to save this in excel as a csv file. However, a message came up saying that part of the format was uncompatable but did I want to save anyway,this I did.

Problem is whenever I save it as a txt file again with this aim of importing the amended data, the leading comma and all the quotation marks are gone. It appears something like this in notepad:

0027892, Mr & Mrs Bloggs, 0, 1, 1

Any ideas as to what I'm not doing correctly?

Sorry about the longwinded post.

Matt

="</br><a href"=http://66.55.51.198/default.htm?cmd=ZOOMPARCEL&folio="&$K2&"&folionum="&$K2&I2"

after the href, the quotation mark is making excel brakeup the function into pieces when I really do need a quotation mark there.

Any ideas other then multiple cells?

Thanks,
Pavel

I imported a member list into Excel in which I need to find any names or
addresses that have quotation marks (") in them. When I try use the search()
function it tells me the entry is invalid. Any ideas?

Hi

The following macro provided by Jason of this forum, saves the content of a cell in column B as a unicode text file with file name from the adjacent cell in column A.

I am using this macro to format dictionary entries for use with Mobipocket Creator (ebook software) which requires that each entry in the dictionary is saved as a separate text file. This macro enables me to convert dictionaries that are in an excel spreadsheet to a form that can be used by Mobipocket Creator.

However, I am having a problem with quotation marks. Whenever there is a quotation mark in a cell in column B, Excel puts additional quotation marks in the output file.

For example, when the macro saves the following:

He said, "Hi!"

I open the resulting text file and it shows:

"He said, ""Hi!"""

Excel has enclosed the quotation marked section in quotation marks and enclosed the whole sentence in quotation marks as well. How can I get it to save the text properly?

Sub MakeTextFiles()

Dim Wb As Workbook
Dim Ws1 As Worksheet, Ws2 As Worksheet
Dim Cell As Range, Rng As Range
Dim lastRow As Long
Dim fPath As String, sWb As String, sPath As String, sWs As String

Set Wb = ThisWorkbook
sWb = Wb.Name
sPath = Wb.Path

Set Ws1 = Sheets("Sheet1") 'change to name of sheet with the data
Set Ws2 = Sheets("Sheet2") 'change to name of a blank sheet
fPath = "C:Temp" 'change to the correct path for text files
sWs = Ws2.Name

Application.ScreenUpdating = False
Application.DisplayAlerts = False

With Ws1
lastRow = .Range("A" & Cells.Rows.Count).End(xlUp).Row
Set Rng = .Range("A1:A" & lastRow)
End With

For Each Cell In Rng
Ws2.Range("A1") = Cell.Offset(0, 1)
Ws2.Activate
ThisWorkbook.SaveAs fPath & Cell & ".txt", xlUnicodeText
Next Cell

Ws2.Range("A1").ClearContents
Ws1.Activate
Ws2.Name = sWs

ThisWorkbook.SaveAs sPath & Application.PathSeparator & sWb, xlWorkbookNormal

Application.ScreenUpdating = True
Application.DisplayAlerts = True

End Sub


No luck finding an answer? You could always try Google.