Adding new line character to schedule.

Adding new line character to schedule.

halukuzuner
Advocate Advocate
764 Views
6 Replies
Message 1 of 7

Adding new line character to schedule.

halukuzuner
Advocate
Advocate

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?

 

halukuzuner_0-1686147099025.png

 

0 Likes
765 Views
6 Replies
Replies (6)
Message 2 of 7

ToanDN
Consultant
Consultant

Add them to Separators in the combine parameters dialog.

0 Likes
Message 3 of 7

halukuzuner
Advocate
Advocate

I have already added separator. Separator doesn’t add new line.

0 Likes
Message 4 of 7

anze.kumar
Advocate
Advocate

Maybe you have an issue because the line is sometimes a representation of "minus" (shorter line) and other times as "separator" (longer line).

anzekumar_0-1686157094426.png

 

0 Likes
Message 5 of 7

halukuzuner
Advocate
Advocate

It is not about minus sign. In the picture “/“ used as separator.

0 Likes
Message 6 of 7

ralphdenhaan
Collaborator
Collaborator

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".

 

ralphdenhaan_0-1686165396885.png

 

Select Accept as Solution and Likes are always welcome. 


Ralph den Haan, (Lazy) BIM Specialist


LinkedIn | LazyBIM Blog


 

0 Likes
Message 7 of 7

halukuzuner
Advocate
Advocate

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.

0 Likes