- In Excel make a new column with a simple function (using string concatination with the &-operator) to add the comma's and quotes.
- Copy/paste to Word. Gives a table.
- Convert table to text. Gives each constant on a separate line.
- Use edit>replace>more>special (that's Word XP) to delete the paragraph marks (it helps I've set Word to show them).
It would only take a minute or two, without any stress.
It seems you already succeeded in the first 3 steps on your own. Now all you've got to do is delete spaces and paragraph marks as outlined above. What's the problem here?
I have to enter a bunch of alphanumeric characters into a query in Oracle SQL. This is not a SQL question, but I need to take these alphanumeric characters(everyone 15 digits) and pad the front with ,' and the end with ' soo... a comma and a single quote at the front and a single quote at the end.
I have them currently in an excel spreadsheet in one column.
I tried creating two columns in front and one at the end and then pasting to a word doc/txt file, but I get spaces and the query I need to enter these into does not like the spaces.
I need to select all from one column, pad the front and back, and then paste them into another file without any spaces.
I am stressed over this one, so any help you could provide would be greatly appreciated.