Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Combining Question
I have a worksheet with first, middle and last names of people. The data are
all in separate cells. I would like to combine the name (F M L) in one cell per name. I have used CONCENTATE and it works. However, this is a reference formula which errors when I delete any of the reference cells. So...I need to find a way to combine a person's first, middle and last name in a single cell and actually have that data in there (i.e., to not be a reference). If anyone has any idea on how to do this (short of having to re-input the data), I would greatly appreciate it. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining text and cell value to create a sentence | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Excel question? Regarding cell formula | Excel Worksheet Functions | |||
combining several individual cells of numbers into one cell | Excel Worksheet Functions |