Excel help.

[stephen4785]

I have a worksheet that I made into a table. I want to add a phone number next the names in a specific column without having to copy/paste over every name. I want to edit the one name and have it change every name to that format.
Any ideas

[juiceweezl]

I have a worksheet that I made into a table. I want to add a phone number next the names in a specific column without having to copy/paste over every name. I want to edit the one name and have it change every name to that format.
Any ideas

Not sure exactly what you're asking. If you want phone numbers next to the names, simply insert a column/row and enter the numbers. If you want it in the same cell as the name, insert a column/row and then use the cocantenate (sp) function to combine the cells. Copy/paste it (values only) into a new sheet and you're done.

If you just want to format a cell and then make the others like it, use format painter.

[Silverback]

Sorry, I only know Lotus 1-2-3

[YALE]

I think you need concatenation and vlookup skills. GET THEE TO YOUTUBE!

[yellowstang]

It's a MS product, try right clicking!

[HECDOGGIE]

I have a worksheet that I made into a table. I want to add a phone number next the names in a specific column without having to copy/paste over every name. I want to edit the one name and have it change every name to that format.
Any ideas

Vlookup will work .


Just enter + in the cell, pick VLOOKUP in the upper left tab, highlight your lookup columns, pick return and bam... done

[stephen4785]

Vlookup will work .


Just enter + in the cell, pick VLOOKUP in the upper left tab, highlight your lookup columns, pick return and bam... done

I'll try that.
I made the spreadsheet a table and set a table design so that every other cell is white then blue. Iv been editing the spreadsheet and now certain cell colors are screwed up so several are solid blue. Iv tried highlighting all of the cells and clicking the table design I want but it wont change the colors back. Anyone have an idea? I want the colors to be married to the lines and not change when the info is rearranged.

[VaderTT]

I think you need concatenation and vlookup skills. GET THEE TO YOUTUBE!

Pivot tables even. I'm literally compiling a master compensatory sheet right now with vlookup, hlookup, mid and different types of vba/macros.

[YALE]

Pivot tables even. I'm literally compiling a master compensatory sheet right now with vlookup, hlookup, mid and different types of vba/macros.

Gangster!

[stephen4785]

Got it figured out. I used Find/replace to update the phone number next to the name and then reset the color scheme to normal and reselected the table design I wanted.
Thanks guys