| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Concatenate
I need to merge over 20,000 first and last names and figured out how to do
that in concatnate, but I can't copy the formula into the other 19,000 names I need to do. Can I do this? -- Cathie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Concatenate
Using a formula like:
=A1 & " " & B1 where A1 contains the first name and B1 the surname, you should be able to copy this formula down the column to row 20000. What exactly is the problem? Pete On Aug 27, 2:18*pm, Cathie wrote: I need to merge over 20,000 first and last names and figured out how to do that in concatnate, but I can't copy the formula into the other 19,000 names I need to do. *Can I do this? -- Cathie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate | Excel Worksheet Functions | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
| Concatenate | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
![Cathie[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
