Importing Text with "s around it

  • Thread starter Thread starter croman
  • Start date Start date
C

croman

I have about 14,000 lines of text I need to import into an Exce
spreadsheet

Each one is a number and each number as the "s around it
example: "123456"

I need to keep those, however at the moment, if I paste it into th
Excel spreadsheet it takes them away.. makes it 123456

Is there a way that I can paste the values in there so that it keep
the " marks?

Thanks in advanc
 
I don't know how to paste such strings into Excel without losing the "s
But, you could easily add the "s back once the numbers are pasted int
a workbook. Here's one way. Create an empty column to the left an
right of the column containing the pasted numbers. In these two empt
columns, enter " in each cell for all each row of data. Let's say yo
used columns A, B, and C for that. In other words, A has "s, B ha
your data, and C has "s. In D1 {adjust this if you have header rows}
put =A1&B1&C1. Copy the formula down to all rows containing data i
column B. Then, to covert the strings displayed in column D to text
not formulas, copy column D and paste using Paste Special, Values t
paste that column into any column; if you want, you can even overwrit
column D in this step
 
Croman,

If the reason you want to keep the quote marks is that you'll be writing the
data back to a text file and will want them written there, it might not be
necessary to import them to the worksheet. You can use the Text Write
Program at www.tushar-mehta.com to write a sheet to a text file. It has an
option to force quotes around all fields.
 
To save the quotation marks when doing an import :

In step two of the import, go to the "Text Qualifier" box and choose
none.

This will work IF there is a space between the data items in the text
file AND IF you select "Space" as a delimiter.

If the text file data is as: "123""456" with no space between, you can
still preserve the "s by following this method, but each entire row
will be in one cell. Then, you will have to play with "Text to
Columns" to try and seperate it.

I hope this will help
 
Elsie,

This is a good piece of information. But I don't know why it's posted as a
reply to mine. I've noticed that with ExcelForum posts -- that's why I
mention it.
 
How can one tell whether a post was intended for them or someone else i
a thread, unless the username is included in the post, or the messag
being responded to is quoted? Is there some other sign
 
Dderolph,

I don't know how it appears in ExcelForum, but in regular newsreader
programs (Outlook Express) replies are indented under the post being replied
to, so it's easy to see the threads.
 
?> I don't know how it appears in ExcelForum, but in regular newsreader
programs (Outlook Express) replies are indented under the post being
replied o, so it's easy to see the threads.
Click to expand...

Thanks for your response.
Can you give me some info or tell where I can get info on how to view
these threads in Outlook Express instead of in my web browser
 
You might want to start by getting a free email account (hotmail, yahoo),
and using that in the newsgroups, just in case someone needs to send you an
email -- doesn't happen often, just like threads don't normally go past
5 on subject replies. Make sure you turn on their filters to filter out
most of the spam, so you won't have to see it in your inbox.

Outlook Express 5.0 through 6.0
http://www.mvps.org/dmcritchie/ie/oe6.htm

Outlook Express 6.0, Newsgroups
http://www.mvps.org/dmcritchie/ie/oe6nws01.htm

Don't forget to set you rules for email an newsgroups
see top of page in oe6nws01.htm for a link.

You don't have to start by reading in all the messages
so you might want to start by reading only 200 message,
then use "Catch Up" which means you won't be reading
old messages, then take off the restriction of how many
messages you read in. Use rightclick (context) menus
a lot to mark threads as being read if you don't want to
look at them.
 
Back
Top