Microsoft Office Tutorials and References
In Depth Information
Figure 16-15: Using a lookup table to assign a region for a state.
Joining columns
To combine data in two more columns, you can usually use the concatenation operator (&) in a formula. For ex-
ample, the following formula combines the contents of cells A1, B1, and C1:
=A1&B1&C1
Often, you'll need to insert spaces between the cells. For example, if the columns contain a title, first name, and
last name. Concatenating using the preceding formula would produce something like Mr.ThomasJones . To add
spaces (to produce Mr. Thomas Jones ), modify the formula like this:
=A1&” “&B1&” “&C1
Search JabSto ::




Custom Search