need a little excel help...

[makken85]

Hey guys,

I have a rather large excel spreadsheet contain data on several cities.
I need to add the city ID number to the left of the column with the city name, I have a seperate spreadsheet that has the city name with the ID number next to it.

The problem is that my original spreadsheet does not follow the formating of the second spreadsheet (eg. the second spreadsheet has Sacramento listed as "Sacramento City", however, on the first spreadsheet, it's listed as "Sacramento, City of")

I was wondering if there was a way to easily lookup the data corresponding to the first spreadsheet without doing it manually

Thanks.

 

[makken85]

Oh, a second thing I need is a way to combine two text cells.

Say Cell one has "textstring1", and cell two has "textstring2", is there a way to make a cell 3 with "textstring2, textstring1"?

and the inverse of it

Say cell one has "textstring2, textstring1" is there a way to make cell two with "textstring1" and cell3 with "textstring2"?

 

[Bug]

Okay, it seems you have 3 questions there. I'll try to answer the 2nd one regarding combining the contents of 2 cells into 1.

I think you're looking for something called "Concatenation". It uses the ampersand to join the contents of cells together.
For example,
A1 = Anandtech
B1 = Technical Support
C1 = A1&" "&B1
So the resulting value displayed in C1 would appear as
Anandtech Technical Support

The reason I enclosed a space within quotation marks is b/c Concatenation does not automatically adjust for punctuation. Without the " ", C1 would display
AnandtechTechical Support

 

[lansalot]

Check out the hlookup, vlookup and lookup commands in the excel help.

 

[Richard98]

Originally posted by: makken85
and the inverse of it

Say cell one has "textstring2, textstring1" is there a way to make cell two with "textstring1" and cell3 with "textstring2"?

the easiest way to do this would be DATA - Text to columns. You could also use string formulas (left, mid, right)