Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hmm Still stuck
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 :)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hmm Still stuck
PLEASE, don't post the same question all over the place - I've answered
this in public.excel. Pete DB wrote: 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 :)) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hmm Still stuck
Cheers Pete.....Thats me bollocked....
Thanks Dave :)) "Pete_UK" wrote in message ups.com... PLEASE, don't post the same question all over the place - I've answered this in public.excel. Pete DB wrote: 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 :)) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hmm Still stuck
eg.
if in A10 you have Deepak then in K10 enter "=A10" (without quotes) "DB" wrote: Cheers Pete.....Thats me bollocked.... Thanks Dave :)) "Pete_UK" wrote in message ups.com... PLEASE, don't post the same question all over the place - I've answered this in public.excel. Pete DB wrote: 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 :)) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hmm Still stuck
what's wrong with copy, paste? stupid question maybe
-- Allllen "Deepak" wrote: eg. if in A10 you have Deepak then in K10 enter "=A10" (without quotes) "DB" wrote: Cheers Pete.....Thats me bollocked.... Thanks Dave :)) "Pete_UK" wrote in message ups.com... PLEASE, don't post the same question all over the place - I've answered this in public.excel. Pete DB wrote: 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 :)) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hmm Still stuck
Copy and paste would take yonks.........I have the work rota on one side of
the screen and I just want a simple....... name.....duty........each days hours..........copied into a small template that I later print out and hand out to the workers... Im 25% done and it is working a treat.....it will take a little while to set up but once done it'll save hours of work... Dave :) "Allllen" wrote in message ... what's wrong with copy, paste? stupid question maybe -- Allllen "Deepak" wrote: eg. if in A10 you have Deepak then in K10 enter "=A10" (without quotes) "DB" wrote: Cheers Pete.....Thats me bollocked.... Thanks Dave :)) "Pete_UK" wrote in message ups.com... PLEASE, don't post the same question all over the place - I've answered this in public.excel. Pete DB wrote: 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 :)) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hmm Still stuck
Why does copy/paste take "yonks"? You can copy a virtually unlimited number of
cells in one operation. Or, if you design your spreadsheet properly, copy the whole column. It's a simple two-step operation -- done in less than 5 seconds. -- Regards, Fred "DB" wrote in message k... Copy and paste would take yonks.........I have the work rota on one side of the screen and I just want a simple....... name.....duty........each days hours..........copied into a small template that I later print out and hand out to the workers... Im 25% done and it is working a treat.....it will take a little while to set up but once done it'll save hours of work... Dave :) "Allllen" wrote in message ... what's wrong with copy, paste? stupid question maybe -- Allllen "Deepak" wrote: eg. if in A10 you have Deepak then in K10 enter "=A10" (without quotes) "DB" wrote: Cheers Pete.....Thats me bollocked.... Thanks Dave :)) "Pete_UK" wrote in message ups.com... PLEASE, don't post the same question all over the place - I've answered this in public.excel. Pete DB wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stuck Button effect in Excel | Excel Discussion (Misc queries) | |||
stuck | Excel Worksheet Functions | |||
Please help me; my cursor is stuck in drag mode | Excel Discussion (Misc queries) | |||
mouse stuck in cell selection mode | Excel Discussion (Misc queries) | |||
Select is "stuck" | Excel Discussion (Misc queries) |