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
Printable View
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
what about
="""&A1&"""
?
will do it but not for a cell in situ.Code:=""""&G6&""""
So otherwise a macro:
[vba]Sub blah()
For Each cll In Selection.Cells
cll.Value = """" & cll.Value & """"
Next cll
End Sub
[/vba]will do this for the currently selected range. If there are any formulae in the selection, they will be converted to values.
p54cal
4 sets of " did it. Thanks guys.