Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Need help to get single quote in every cell of Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 23-02-2012
Member
 
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.

Reply With Quote
  #2  
Old 23-02-2012
Member
 
Join Date: Jun 2011
Posts: 798
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.
Reply With Quote
  #3  
Old 23-02-2012
Member
 
Join Date: Jun 2011
Posts: 487
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Need help to get single quote in every cell of Excel"
Thread Thread Starter Forum Replies Last Post
How to combine text of multiple row in a single cell of Excel YajasK MS Office Support 2 17-02-2012 01:00 PM
How to get single apostrophe in cell of Excel AsceTic! MS Office Support 2 15-02-2012 05:06 PM
How to get rid of single quote in Microsoft Excel sheet Wisaal MS Office Support 2 10-02-2012 05:22 PM
How to fix maximum text in single cell of Microsoft Excel Irritator MS Office Support 2 03-02-2012 07:47 PM
How to Split a Single Cell in Microsoft Excel 2007 Corey Dunnett Windows Software 2 11-01-2012 12:48 PM


All times are GMT +5.5. The time now is 09:42 AM.