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
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
Peace of mind is found in some of the strangest places.
what about
="""&A1&"""
?
will do it but not for a cell in situ.=""""&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
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
4 sets of " did it. Thanks guys.
Peace of mind is found in some of the strangest places.
Posting Permissions
Reply With Quote
