| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging text columns
My work sheet looks like this:
4616 l STOKES l ST 2844 l OAKDALE l ST 2919 l KING COLE l DR 3504 l COLONIAL l AVE 3218 l SUNNYVALE l ST 2837 l OAKDALE l ST 3714 l SUNNYVALE l ST I want to merge to be like this "4616 STOKES ST". Whats the easiest way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging text columns
=A1&" "&B1&" "&C1
or =CONCATENATE(A1," ",B1," ",C1) Hope this helps. -- John C "RyanR8881" wrote: My work sheet looks like this: 4616 l STOKES l ST 2844 l OAKDALE l ST 2919 l KING COLE l DR 3504 l COLONIAL l AVE 3218 l SUNNYVALE l ST 2837 l OAKDALE l ST 3714 l SUNNYVALE l ST I want to merge to be like this "4616 STOKES ST". Whats the easiest way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging text from 3 columns to create a URL | Excel Worksheet Functions | |||
| merging columns | New Users to Excel | |||
| merging text columns | Excel Discussion (Misc queries) | |||
| WRAP a text line over several columns without merging cells | Excel Worksheet Functions | |||
| WRAP a text line over several columns without merging cells | Excel Worksheet Functions | |||
Linear Mode
