Hmm Stuck...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DB - 23 Nov 2006 20:47 GMT

I have a file on excel that contains many text entries of peoples names.....

A10 has Ken in it
A11 has Bill in it
A12 has Alan in it etc etc etc....

I want to copy these names over to K10
K11
K12..............

The first column is set for text......but i tried the autosum and told it
that K10 = A10,,,,i thought it would just copy the text of the persons name
but it didnt, it just has =SUM(A10) in the cell.

What am I doing wrong?

I'm sure there must be a simple solution but i'm stuck and can't find it.
Can you put me out of my misery and tell me what i'm doing wrong.

Many Many thanks

Dave :))

Reply to this Message

Pete_UK - 23 Nov 2006 20:59 GMT

The cell K10 is probably formatted as text - use Format | Cells |
Number (tab) and select General. Then enter a new formula:

=A10

"Ken" should appear, and if you type a different name into A10 then K10
will display the new name. SUM( ) is used to add together the (numeric)
values of cells in a range, and is totally inappropriate here.

Hope this helps.

Pete

> I have a file on excel that contains many text entries of peoples names.....
>
[quoted text clipped - 18 lines]
>
> Dave :))

Reply to this Message

DB - 23 Nov 2006 21:34 GMT

Cheers Pete......

so simple.....

many thanks for your help.

Dave :))))

> The cell K10 is probably formatted as text - use Format | Cells |
> Number (tab) and select General. Then enter a new formula:
[quoted text clipped - 33 lines]
>>
>> Dave :))

Reply to this Message

Pete_UK - 23 Nov 2006 22:29 GMT

Thanks for feeding back - I have the feeling that you'll be back <g>

Pete

> Cheers Pete......
>
[quoted text clipped - 41 lines]
> >>
> >> Dave :))

Reply to this Message

DB - 23 Nov 2006 23:07 GMT

You could be right Pete.....but me thinks i'll stick to one group instead of
shouting at the whole world...

Thanks again

Dave :)

> Thanks for feeding back - I have the feeling that you'll be back <g>
>
[quoted text clipped - 48 lines]
>> >>
>> >> Dave :))

Reply to this Message

Pete_UK - 23 Nov 2006 23:19 GMT

I think you'll find that most people who provide solutions read all the
groups, anyway, so you don't need to post in several - this will save
YOU time, as well, as you only need to read responses to one thread,
rather than several.

Pete

> You could be right Pete.....but me thinks i'll stick to one group instead of
> shouting at the whole world...
[quoted text clipped - 55 lines]
> >> >>
> >> >> Dave :))

Reply to this Message