how to put all words(separately) between quotations?

Nestor Klan: You could use something like below. Copy the formula and paste it into B1=""""&A1&""""Copy down the list, then Copy and Paste Values. If you have multiple words in each cell, then=""""&SUBSTITUTE(A1," ",""" """)&""""(all of those are double quotation marks)Here's a macro (only does one-word cells)Sub QuotationMarks()For Each cell In Range("A1", Range("A1").End(xlDown))cell.Value = """" & cell.Value & """"NextEnd Sub...Show more

Davis Zou: Yah, what Henry said...he got it to it first.