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

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

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

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

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

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

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

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