I Have A List Of 3215 Product Names On A Spreadsheet. Each Resides In A Single Cell. I Need To Put Each Name In Quotes. The Names Are All In One Column?

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

Home MS Excel

⟩ I have a list of 3215 product names on a spreadsheet. Each resides in a single cell. I need to put each name in quotes. The names are all in one column?

If all of your names are in column A, insert a new, temporary column B. The formula for cell B2 would be:

=""""&A2&""""

Yes, there are four sets of quotes there. The first and fourth quote indicate that you need to append text before the value in A2. The 2nd and 3rd quote is a special Excel code to put in a quote mark. Copy the formula from B2 down to B3216. Then, copy column B, and use Paste Special, Values to change the formulas to values.

Is this answer helpful?
0 Yes | 0 No

213 views

More Questions for you:

I wish to count the number of cells in a col or row that have a value > 0. How is this done? The zero is displayed in the cells. Count() will only ignore a blank cell?

There are many monetary signs in Excel97 but I have not found one yet for the new euro currency. Any suggestions?

I am trying to get the percentage of two cells by dividing one cell into the other. Some of the time both cells might have a Zero in each. Therefore the DIV?

I am new at this Excel game. How do you figure elapsed time? I have formatted the cells in military time, create a start time column and an end time column and would like to know the difference?

I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return the color of the interior for each cell in a range? I would like to do something like =countif(b1b10, cell("interior","Red"))?

Thanks for your great answer, but this results in my data be backwards; i.e. rather than 12345 I need it to be 54321. Any further thoughts?

I download data which comes to me in a column. I want to use it in a complex sheet that needs data in a row. How can I convert the column data into row data?

How can I enter the symbol for the new Euro currency in my spreadsheet?

I want to add 25 to all of the cells in column A. I do not want a new column, I want to add it right to the cells in column A?

I use a large spreadsheet on a daily basis with 31 worksheets (one for each day of the month). Each worksheet is huge.I would like to insert another sheet in the workbook and insert a button to copy another worksheet to the end of the workbook and then rename the sheet to the correspondingday of the month?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

Home MS Excel

⟩ I have a list of 3215 product names on a spreadsheet. Each resides in a single cell. I need to put each name in quotes. The names are all in one column?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home MS Excel

⟩ I have a list of 3215 product names on a spreadsheet. Each resides in a single cell. I need to put each name in quotes. The names are all in one column?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: