| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Major Help Needed Asap
Hey Guys Its Sunday 7:44 am est and i have a forum i need to finish today but am a total Newb at Excel. This will be an easy question for all of you i am sure columm A on my sheet has names in it that goes about 57 lines deep. Is there a way to highlight the columm and put a coma to seperate it from columm b with just one click of a button instead of going person by person and doing it? -- ninjashadow80 ------------------------------------------------------------------------ ninjashadow80's Profile: http://www.excelforum.com/member.php...o&userid=36662 View this thread: http://www.excelforum.com/showthread...hreadid=564083 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Major Help Needed Asap
come on fellas this has to be an asy question for most of you -- ninjashadow80 ------------------------------------------------------------------------ ninjashadow80's Profile: http://www.excelforum.com/member.php...o&userid=36662 View this thread: http://www.excelforum.com/showthread...hreadid=564083 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Major Help Needed Asap
I assume that the data begins with "a1" and "b1"
If so go to "c1 " and enter =a1 & "," & b1 then fill down to the end of your 57 lines. HTH cil "ninjashadow80" wrote in message news:ninjashadow80.2beclg_1153655407.6893@excelfor um-nospam.com... Hey Guys Its Sunday 7:44 am est and i have a forum i need to finish today but am a total Newb at Excel. This will be an easy question for all of you i am sure columm A on my sheet has names in it that goes about 57 lines deep. Is there a way to highlight the columm and put a coma to seperate it from columm b with just one click of a button instead of going person by person and doing it? -- ninjashadow80 ------------------------------------------------------------------------ ninjashadow80's Profile: http://www.excelforum.com/member.php...o&userid=36662 View this thread: http://www.excelforum.com/showthread...hreadid=564083 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Major Help Needed Asap
you can also use the concatenate function
"ninjashadow80" wrote in message news:ninjashadow80.2beclg_1153655407.6893@excelfor um-nospam.com... Hey Guys Its Sunday 7:44 am est and i have a forum i need to finish today but am a total Newb at Excel. This will be an easy question for all of you i am sure columm A on my sheet has names in it that goes about 57 lines deep. Is there a way to highlight the columm and put a coma to seperate it from columm b with just one click of a button instead of going person by person and doing it? -- ninjashadow80 ------------------------------------------------------------------------ ninjashadow80's Profile: http://www.excelforum.com/member.php...o&userid=36662 View this thread: http://www.excelforum.com/showthread...hreadid=564083 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Major Help Needed Asap
You have names in Column A.
So far that's all we know. Single names like George or first/last like George Peters? What is in Column B? Do you want to join A and B? Not so simple when you don't provide details. Gord Dibben MS Excel MVP On Sun, 23 Jul 2006 08:01:21 -0400, ninjashadow80 wrote: come on fellas this has to be an asy question for most of you |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Major Help Needed Asap
I have things in columm A thru E. I need each columm to be seperated by a comma -- ninjashadow80 ------------------------------------------------------------------------ ninjashadow80's Profile: http://www.excelforum.com/member.php...o&userid=36662 View this thread: http://www.excelforum.com/showthread...hreadid=564083 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Major Help Needed Asap
Let me give you some advice.
*Everyone* here *IS* here for the express purpose of helping someone. If you're no getting any help, it's probably because no one understands you. I know that I don't. Why didn't you reply to CIL this morning and say what was wrong with that suggestion? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ninjashadow80" wrote in message news:ninjashadow80.2bf8jj_1153696810.0423@excelfor um-nospam.com... I have things in columm A thru E. I need each columm to be seperated by a comma -- ninjashadow80 ------------------------------------------------------------------------ ninjashadow80's Profile: http://www.excelforum.com/member.php...o&userid=36662 View this thread: http://www.excelforum.com/showthread...hreadid=564083 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Major Help Needed Asap
Are you trying to create a file that shows this data with commas between each column? In that case, save the file as a csv file, and it will do it for you. (File, Save As, change file type to csv, and save). Is this what you want? Regards Mike -- Mikeopolo ------------------------------------------------------------------------ Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570 View this thread: http://www.excelforum.com/showthread...hreadid=564083 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sports Comp Ladder tabulating help needed | Excel Worksheet Functions | |||
| i need to find duplicates! ASAP | Excel Worksheet Functions | |||
| "In Today's Dollars" help needed... | Excel Worksheet Functions | |||
| Vlookup Help needed ASAP | Excel Worksheet Functions | |||
| Need a Formula ASAP | Excel Worksheet Functions | |||
Linear Mode
