Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Combining Cell Info
I have the following columns in Excell 2007:
A=Year; B=Title; C=FirstName; D=MiddleName; E=LastName; F=Suffix; G=Address; H=City; I=State; J=ZIP. I want to e able to combine cells so that the columns contain: A=Year; B=Title FirstName MiddleName LastName Suffix; C=Address; D=Street, City ZIP. Can someone tell me *exactly* how to do this? I've tried following Help using the " and & signs, using CONCATINATION (I don't understant any of this) but to no avail. Thanks. Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Combining spread sheet info | Setting up and Configuration of Excel | |||
how do i get excel to see info in one cell, look at info in anoth. | Excel Discussion (Misc queries) | |||
combining 3 columns of same info for a pivot table | Excel Worksheet Functions |