Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Editing in Excel

Editing in Excel

Editing in Excel

How can I put quotes around all the text in the cells in a spreadsheet w/o doing it manualy?

RE: Editing in Excel

Put a blank column to the left and a blank column to the right of your text column. You'll need another blank column, too. So here's your layout:

Column A is blank. Put a quote mark in the first cell, copy down.

Column B has your text in it.

Column C is blank. Put a quote mark in the first cell, copy down.

Column D is blank. Use this formula and copy it down:


Then, select the cells in D, copy them, don't move cursor! Hit Edit-Paste Special-Values to remove the underlying formula. Then delete columns A, B, and C.


RE: Editing in Excel

Here is a sub that will at the " marks as you type in designated cells. Highlight the cells you want handled and then range name them myrange. Everything will be automatic from then on.

This will not change text that is already in the cell unless you edit the text. You can hit F2 for cell edit and then hit enter.


Private Sub Worksheet_Change(ByVal Target As Excel.Range)
' Add " marks before and after text in myrange
' Use F2 (cell edit) and Enter to update text already in the cell
Dim TempString As String

If Application.Intersect(Target, Range("myrange")) Is Nothing Then
    Exit Sub
End If
If Target.Cells.Count > 1 Then
    Exit Sub
End If
If Target.Value = "" Then
    Exit Sub
End If

Application.EnableEvents = False
    TempString = Chr(34) & Target.Value & Chr(34)
    Target.Value = TempString

Application.EnableEvents = True

End Sub

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close