How to Import Visio Text Boxes into Excel as Text
 

I am working off a document created by someone else in Visio. They have
create a 'spreadsheet' using lines and individual text boxes. I want to
import/copy this text from visio(ideally keeping the formatting, but not
essential) and paste it into Excel cells.

If I select one text box from visio and copy and paste it into excel, it
pastes the text into a cell as text (which is what I want). However, If I
select multiple text boxes it will paste this into excel as an image. I have
tried paste special but this only gives me different image types to paste it
as.

Can anyone assist or point me in the right direction.

Or am I barking up a non-existent tree?

Thanks!

How to Import Visio Text Boxes into Excel as Text
 

I have pased this doing print screen and then crop it using the picture tool
bar. In Excel but not editable if that is a word.

"Nick_adminator" wrote:

I am working off a document created by someone else in Visio. They have
create a 'spreadsheet' using lines and individual text boxes. I want to
import/copy this text from visio(ideally keeping the formatting, but not
essential) and paste it into Excel cells.

If I select one text box from visio and copy and paste it into excel, it
pastes the text into a cell as text (which is what I want). However, If I
select multiple text boxes it will paste this into excel as an image. I have
tried paste special but this only gives me different image types to paste it
as.

Can anyone assist or point me in the right direction.

Or am I barking up a non-existent tree?

Thanks!

How to Import Visio Text Boxes into Excel as Text
 

I am wanting to paste the info as text in the excel spreadsheet so I can
manipulate the text and cells from there. I am not wanting an image as this
cannot be edited.

But thanks for your comments.

"Don" wrote:

I have pased this doing print screen and then crop it using the picture tool
bar. In Excel but not editable if that is a word.

"Nick_adminator" wrote:

I am working off a document created by someone else in Visio. They have
create a 'spreadsheet' using lines and individual text boxes. I want to
import/copy this text from visio(ideally keeping the formatting, but not
essential) and paste it into Excel cells.

If I select one text box from visio and copy and paste it into excel, it
pastes the text into a cell as text (which is what I want). However, If I
select multiple text boxes it will paste this into excel as an image. I have
tried paste special but this only gives me different image types to paste it
as.

Can anyone assist or point me in the right direction.

Or am I barking up a non-existent tree?

Thanks!