anyone good with excel?

I need to take a name from 2 cells and make it equal one string in another with last name then first name. For example John in A1 and Smith in B1 I need them to look like "Smith, John" including the comma and quotations. So far i've got =PROPER(B1&", "&A1) but I cannot figure out how to enter quotations into the formula. Thanks for any help.

 

Why don't you just add " and , to two cells and and just concatenate. so if John is A2 and Smith is B2, add " to A1 and , to B1 and enter: =$A$1&B2&$B$1&A2&$A$1

Then you can just fill down.

Edit: You can also use the "proper" function (i.e. =proper($A$1&B2&$B$1&A2&$A$1)) if you need to.

 

=proper(concatenate("""",b1,",",a1,""""))

 

I thought I was but it turns out I'm friggin horrible at it. Ended up having to type in two columns with 965 lines each of individual numbers.

Nope, I'm damn bad with excel. Even worse with word.

 

=proper(""""&b1&","&a1&"""")

learning something new today.

 

klebs the last one did it perfectly, thanks alot.

 

=concatenate("""",b1,",",a1,"""") works as well.

 

Adding to the thread...

I've got a column of numbers used as type IDs from 1 to 25,000. I need to add leading zeros so that each cell in the column has the same number of digits. "1" becomes "00001", "25" becomes "00025", and so on.

Anybody had to do this before?

 

If value of a1 is 0 or 1 add this to the value of b1:
=RIGHT("00000" & A1, 5) I think.
You should get 00000 or 00001. After that just click and drag it all the way down.

 

Can also just format cells, custom, and type 00000. Then apply the format to all the cells.

 

Yeah I gues that works too.