Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate question
Assuming D1 has:
=A1 & B1 & C1 then copy column D and paste/special/value back onto itself. Then columns A, B, and C can be deleted. -- Gary''s Student - gsnu200776 "DianaL" wrote: I used the concatenate function to combine columns of Last Name, First Name, Middle Initial. Now, I want that combined information to remain and I want to delete the three separate columns. How can I do that without losing the concatenate function? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONCATENATE Question | Excel Discussion (Misc queries) | |||
Concatenate Question | Excel Worksheet Functions | |||
IF(ISTEXT Concatenate formula question | Excel Worksheet Functions | |||
Concatenate question | Excel Worksheet Functions | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel |