Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine 2 cells without using the CONCATENATE function
Help.
I am importing .xls information into a custom / proprietary contact manager system. Problem is the Excel address information comes in 2 columns 1) the house number and 2) the street address. If I combine the columns using the CONCATENATE formula, the import does not work correctly. Is there a way to actually Move the cell information and combine them? Is there a Macro guru out there with a great answer? Any Help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine 2 cells without using the CONCATENATE function
What if you concatenate them as you want, then copy them and paste special
as values in place and then delete the original 2 columns? -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "JBG" wrote in message ... Help. I am importing .xls information into a custom / proprietary contact manager system. Problem is the Excel address information comes in 2 columns 1) the house number and 2) the street address. If I combine the columns using the CONCATENATE formula, the import does not work correctly. Is there a way to actually Move the cell information and combine them? Is there a Macro guru out there with a great answer? Any Help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine 2 cells without using the CONCATENATE function
I actually thought I tried this, but it looks like this will work perfect.
Thanks a lot for your answer. "Peo Sjoblom" wrote: What if you concatenate them as you want, then copy them and paste special as values in place and then delete the original 2 columns? -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "JBG" wrote in message ... Help. I am importing .xls information into a custom / proprietary contact manager system. Problem is the Excel address information comes in 2 columns 1) the house number and 2) the street address. If I combine the columns using the CONCATENATE formula, the import does not work correctly. Is there a way to actually Move the cell information and combine them? Is there a Macro guru out there with a great answer? Any Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Use TREND function with nonadjacent cells | Excel Worksheet Functions | |||
Concatenate function - keeping "displayed" extra digits | Excel Discussion (Misc queries) | |||
write a function to determine if cells have names | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions |