Printable View
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.
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.
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.