Clear Contents except first character

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mikesmith200550 - 17 Mar 2006 18:00 GMT

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

Reply to this Message

kraljb - 17 Mar 2006 18:11 GMT

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

Reply to this Message

Andy - 17 Mar 2006 18:16 GMT

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.

> I have an excel spreadsheet which contains answers to a survey (many
> rows of columns of answers, each column is the answer to a question).
[quoted text clipped - 14 lines]
> Thanks,
> PS - I have Excel 2000 and Excel 2003

Reply to this Message