[Vince]

If you paste into Excel you can then use the ‘Textjoin’ function to create a single line then delete the original text e.g. if you have copied & pasted from Bluebeam and you have text in cells A1 to A9 then use

=TEXTJOIN(” “,,A1:A9)

[Matt Hackman]

Awesome thank you.

What about if I pasted it all into a single cell and it retains all the returns?

[Vince]

Try =SUBSTITUTE(A1,CHAR(10), ” “)

[David Cutler]

I’ve had good luck saving PDFs as Word documents and then copying the text I need from there. I can’t say that I’ve ever tried it with a drawing though…

[Doug McLean]

Try the Export to Word function.

Might work better

[Vince]

There is also supposed to be another method in Excel using the ‘Find and Replace’ function.

Apparently in the find box you press ctrl + j the. In the replace box you put a space.

I’ve managed to get this to work a couple of times but most of the time I get an error message.

I’m not sure if there is a similar function in Word?

[Paul Kuehnel]

In word, select the text you have pasted > click ctrl+H (find and replace) > click the “more” button > place your cursor in the find field > click “special” at the bottom of the window > paragraph mark > leave the replace field blank > click replace all.

This will find all the paragraph marks in your selected text and delete them (replace them with nothing).

[Troy DeGroot]

@matt-hackman Have you tried the export to Excel or Word functions under the File menu? You can draw a region around a drawing schedule and export it directly to Excel. Maybe this would help?…