PDA

View Full Version : Solved: Put quotes around text in cells



austenr
08-21-2007, 05:06 PM
Is there a formula that can place double quotes around text in cells. I need to do it for columns A:O. If not a macro will do. Thanks

tpoynton
08-21-2007, 05:26 PM
what about

="""&A1&"""

?

p45cal
08-21-2007, 05:27 PM
=""""&G6&""""will do it but not for a cell in situ.
So otherwise a macro:
Sub blah()
For Each cll In Selection.Cells
cll.Value = """" & cll.Value & """"
Next cll
End Sub
will do this for the currently selected range. If there are any formulae in the selection, they will be converted to values.
p54cal

austenr
08-21-2007, 05:36 PM
4 sets of " did it. Thanks guys.