Due to submission requirements I need to combine parameters. It is easy in Revit. But I want to add new line character between each parameter in order to see them in one cell in Excel. Is there a way to do it with Revit's native functionality?
Maybe you have an issue because the line is sometimes a representation of "minus" (shorter line) and other times as "separator" (longer line).
Hi,
I don't think this is possible in the Revit Native software (when using combined parameters). But you are working in Excel, right? Excel has formulas to fix your problem. Use this formula in a new column and use the "/" as a separator:
=SUBSTITUTE(A1;"/";CHAR(10))
Make sure the cell's formatting is set to "Wrap Text".
Select Accept as Solution and Likes are always welcome.
Ralph den Haan, (Lazy) BIM Specialist
I can do it in Excel. But my wonder is if it is possible in Revit. It is repetitive job. I don’t want to do the same job in excel every time.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.