really stuck...

  • Thread starter Thread starter DB
  • Start date Start date
D

DB

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 :))
 
Answered in the Misc group.


"DB" <[email protected]>
wrote in message
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 :))
 
If I understand you correctly, in K10, enter the formula =A10 then copy
the formula down the column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hmm Stuck... 5
Hmm Still stuck 6
Remove specific cells in a column. 2
Problem writing formula 3
Use lookup to write to cell 8
=Trend question 1
Copy and paste every x number of cells 2
using For statement for populting textbox references 1

Back
Top