Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting In Coma's Need Major Help
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=564084 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting In Coma's Need Major Help
please help me this has to be a easy 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=564084 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting In Coma's Need Major Help
am not to sure what you asking us to advise you on
are you on about joining col a & b with a colum seperator ? "ninjashadow80" wrote: please help me this has to be a easy 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=564084 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting In Coma's Need Major Help
ninjashadow80 Wrote: would help if i didnt spell comma as coma 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 comma to seperate it from columm b with just one click of a button instead of going person by person and doing it? you could insert a new column for your commas or use a formula such as =A1&", "&B1 -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=564084 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting In Coma's Need Major Help - Using Text To Columns?!?
the easiest way to separate all the names would be to use "text to columns"
under the "Data" menu. This allows you to convert each name into a separate column in an extremely fast manner. First ensure you have plenty of spare columns. If you have any doubts copy the column you wish to split to a brand new blank spreadsheet. with the data highlighted --Click on "Data" in the menu bar --Click on "Text to columns" --Select the option most appropriate (if the names are the same length then you could use fixed width: however I suspect you will need to use a "space" so choose the first option) probably "Delimited" --Click on Next --remove the tick from "Tab" and click inside the "Space" tick box --as you do this you should see an example of how your data will now appear in separate columns, click on Next --If you need to format any of the data for anything other than text use this screen to select the column and the option in the top right corner to change the format. -- you are now ready to click on " Finish" You should now have all your data displayed in separate columns Hope this is helpful and what you wanted to happen!! Wendy :) 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=564084 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting In Coma's Need Major Help - Using Text To Columns?!?
I am not sure that I understand the problem. If the names are like "John
Smith" and you want "John,Smith" instead Substitute will do the trick. e.g set up a new column =SUBSTITUTE(C1," ",",",1). David F. Cox "Wendy FP" wrote in message ... the easiest way to separate all the names would be to use "text to columns" under the "Data" menu. This allows you to convert each name into a separate column in an extremely fast manner. First ensure you have plenty of spare columns. If you have any doubts copy the column you wish to split to a brand new blank spreadsheet. with the data highlighted --Click on "Data" in the menu bar --Click on "Text to columns" --Select the option most appropriate (if the names are the same length then you could use fixed width: however I suspect you will need to use a "space" so choose the first option) probably "Delimited" --Click on Next --remove the tick from "Tab" and click inside the "Space" tick box --as you do this you should see an example of how your data will now appear in separate columns, click on Next --If you need to format any of the data for anything other than text use this screen to select the column and the option in the top right corner to change the format. -- you are now ready to click on " Finish" You should now have all your data displayed in separate columns Hope this is helpful and what you wanted to happen!! Wendy :) 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=564084 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting In Coma's Need Major Help
No forget nams its basically i have things in columms A thru E. I need each columm seperated by question marks -- ninjashadow80 ------------------------------------------------------------------------ ninjashadow80's Profile: http://www.excelforum.com/member.php...o&userid=36662 View this thread: http://www.excelforum.com/showthread...hreadid=564084 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting In Coma's Need Major Help
What?? So what's the question? -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=564084 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting In Coma's Need Major Help
Hi
Try =A1&","&B1&","&C1&","&D1&","&E1 -- Regards Roger Govier "ninjashadow80" wrote in message news:ninjashadow80.2bf8ji_1153696808.7018@excelfor um-nospam.com... No forget nams its basically i have things in columms A thru E. I need each columm seperated by question marks -- ninjashadow80 ------------------------------------------------------------------------ ninjashadow80's Profile: http://www.excelforum.com/member.php...o&userid=36662 View this thread: http://www.excelforum.com/showthread...hreadid=564084 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
putting symbols front and | Excel Discussion (Misc queries) | |||
I am putting in a date 02-10-06 and its coming up as 10-02-06 | Excel Worksheet Functions | |||
how to have numbers add/sub without putting = infront | New Users to Excel | |||
how can i fix one entire column after putting my formula there so. | Excel Worksheet Functions | |||
Is there a size limit for putting a excel webpage online? | Excel Discussion (Misc queries) |