Results 1 to 3 of 3

Thread: Need help to get single quote in every cell of Excel

  1. #1
    Join Date
    Jan 2011
    Posts
    22

    Need help to get single quote in every cell of Excel

    I am trying to make all of the cells in a particular column (they are filled with numbers) alphanumeric and left justified by putting a single quote in front of each cell. I don't want to type the quote on each cell. How can I do this without typing in each cell.

  2. #2
    Join Date
    Jun 2011
    Posts
    804

    Re: Need help to get single quote in every cell of Excel

    Insert a column next to the col ; enter the below formula; copy down as required. =CHAR(39) & A1. Would be interesting to know what you are looking at. If this post helps click Yes.

  3. #3
    Join Date
    Jun 2011
    Posts
    492

    Re: Need help to get single quote in every cell of Excel

    Do you really need the apostrophe. There are two ways for that first select he cells and use Format > Cells > Text second you can select the cells and click the left align tool. This might do the job for you.

Similar Threads

  1. Replies: 2
    Last Post: 17-02-2012, 12:00 PM
  2. How to get single apostrophe in cell of Excel
    By AsceTic! in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 04:06 PM
  3. How to get rid of single quote in Microsoft Excel sheet
    By Wisaal in forum MS Office Support
    Replies: 2
    Last Post: 10-02-2012, 04:22 PM
  4. How to fix maximum text in single cell of Microsoft Excel
    By Irritator in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 06:47 PM
  5. How to Split a Single Cell in Microsoft Excel 2007
    By Corey Dunnett in forum Windows Software
    Replies: 2
    Last Post: 11-01-2012, 11:48 AM

Posting Permissions

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