+ Reply to Thread
Results 1 to 2 of 2

Adding single Quotes to each cell

  1. #1
    Registered User
    Join Date
    10-07-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Adding single Quotes to each cell

    Hi,

    I have spreadsheets and each spreadsheet consists of atleast 5000 cells including numbers and charaters. I need to add single quotes for each cell. For example if A1 is 10000 then '10000' and A2 is demonstration then 'demostration'.

    Not sure how to automate this in each spreadsheet. If someone who is knowledgeable please help.


    Regards,
    Vijay

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Adding single Quotes to each cell

    try this in the immediate window.

    ALT+F11 to open VBE
    CTRL+G to open Immediate window

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1