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?
- 1 Answers
- 669 Views
- I also Faced
- E-Mail Answers
Answer / Gaurav Khare
To add quotes around each cell containing a product name in a single column, follow these steps:
1. Select the entire column containing the product names.
2. Press Ctrl + F (Find and Replace) or right-click and select 'Find & Select'.
3. In the Find what field, enter the following formula: =^"(.*)$
- The caret (^) indicates the beginning of the cell, the double quotes ("") are escaped with a backslash (), and the dot (.) represents any character.
4. Leave the Replace with field blank to remove the special formatting (i.e., leaving the quotes as is).
5. Click Replace All to add quotes around each product name.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between an excel spreadsheet and a database?
How many data formats are available in excel name of them?
What is group mode in excel?
How do I align an excel spreadsheet?
What is concatenation in excel?
What is ctrl w in excel?
What is ms excel theory?
How do you create a box in excel 2016?
What is the definition of goal seek in excel?
How do you auto adjust cells in excel?
How does len work in excel?
What version of excel do I have?
MS Excel Microsoft 
