Clear Contents except first character

[mikesmith200550]

I have an excel spreadsheet which contains answers to a survey (man
rows of columns of answers, each column is the answer to a question)
Each cell in each column contains one of the following answers;
1- Yes
2- Not Really
3- Always
4- Never

*I would like to clear the contents of all the cells so that the onl
thing that appears is the number, not the additional words. Th
numbers are in the first character space of each cell. *
For example if cell B3 says “1- Yes” I want cell B3 to just have “1”
I know how to do this manually, but I know there has got to be a way t
automate this b/c it is a lot of manual work to do.
Please help…also do you think if I put it into Access it would b
easier to do this. Any solution would be welcome.
Thanks,
PS - I have Excel 2000 and Excel 200

 

[kraljb]

Try using this formula and copying it down for the rest of the cells..
=LEFT(B3,1)

Once you have the desired result take the calculated range and copy an
paste as values (-->Edit-->Paste Special-->Paste Values

 

[Guest]

Hi

Use Data/Text to Columns, with the Fixed Width option. You can just click
after the number in the dialog box. Take a backup before you start.

Andy.

"mikesmith200550"