Excel Problem

2 posts · originally from https://geek.digit.in/community/threads/excel-problem.140887/

hi every one

i would like to discuss my problem i m having large excel data sheet in which i normally apply sorting to sort the data party wise. but database which i download from the net is actually starting with ' and then party name. so when i try to sort data on party it is not done because of this ' i tried replace command to replace ' with blank spaces but its not working can anybody help me to sort the data and remove this ' with blank spaces. i m using both version 2003 and 2007. do the needful and prmpt back soon

regards

You can try removing the single quote from Text to Column feature of excel.

Note: Following guide is for Excel 2007:

First make sure, the column is in text format.
Select the column. Right Click on selected column -> Format Cells. In number tab, select Text from the list. And click Ok.
Now, click Data tab on Ribbon -> Select Text to Column
Select Fixed Width radio button. Click Next.
Click select and make the line, on the scale, such that, single quote is selected.
Now Click next.
Then click finish. Make sure, the adjacent column was blank, or this process can overwrite the column.

Now you can delete the column of single quote, and proceed to sort.

Hope that works. :Fingerx: