Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I have problems keeping the merge formula to use as a template.
I can merge multiple cells int o one cell using the & " "& formula in Excel.
It works great. The problem arises when I need to use it again. There must be away to merge contents without having to type that formula over and over. I try to make a template but it does not work, so I have to type the formula &" " for approximately 40 to 50 cells. Does anyone know how I can have one formula to wear I can copy my information and paste it into the merge cells formula and have it work correctly? I am trying to make a template that can bve used repeatedly with out having to type that long formula for each cell. Thankyou, Pierre Abadie |
#2
|
|||
|
|||
Pier You should have the ability to copy that formula in the same way you
do any other formula. Can you give a more specific example of the problem that's occurring? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "PBrunner" wrote in message ... I can merge multiple cells int o one cell using the & " "& formula in Excel. It works great. The problem arises when I need to use it again. There must be away to merge contents without having to type that formula over and over. I try to make a template but it does not work, so I have to type the formula &" " for approximately 40 to 50 cells. Does anyone know how I can have one formula to wear I can copy my information and paste it into the merge cells formula and have it work correctly? I am trying to make a template that can bve used repeatedly with out having to type that long formula for each cell. Thankyou, Pierre Abadie |
#3
|
|||
|
|||
You could use a userdefined function that does the concatenation for you. Take
a look at J.E. McGimpsey's site: http://www.mcgimpsey.com/excel/udfs/multicat.html If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm PBrunner wrote: I can merge multiple cells int o one cell using the & " "& formula in Excel. It works great. The problem arises when I need to use it again. There must be away to merge contents without having to type that formula over and over. I try to make a template but it does not work, so I have to type the formula &" " for approximately 40 to 50 cells. Does anyone know how I can have one formula to wear I can copy my information and paste it into the merge cells formula and have it work correctly? I am trying to make a template that can bve used repeatedly with out having to type that long formula for each cell. Thankyou, Pierre Abadie -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Is is possible to add a hard return to a merge cell formula? | Excel Discussion (Misc queries) | |||
How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions |