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 |