Joint words

Manolocs

Active Member
Joined
Mar 28, 2008
Messages
340
Hello, I have no idea if I can do this in Excel, I had to copy/past many pages of PDFs into a spreadsheet, so many words were past without space in between, like this.... "Mikeisgoing" "Johndoes".... should be "Mike is going" and "John does". Is there a way to fix that? Any Idea?
Thanks in advance.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Hi Manolo
In my experience this sort of problem is related to the PDF browser tool not with the Excel pasting the text
In short change/try different PDF browsers (I like Foxit)
Cheers
Sergio
 
Upvote 0
Hello, I have no idea if I can do this in Excel, I had to copy/past many pages of PDFs into a spreadsheet, so many words were past without space in between, like this.... "Mikeisgoing" "Johndoes".... should be "Mike is going" and "John does". Is there a way to fix that? Any Idea?
Thanks in advance.

Short answer - no :(

How would excel know where to add the spaces?
thesetable
these table
the set able
(dumb example, but it shows what I mean)
 
Upvote 0

Forum statistics

Threads
1,223,236
Messages
6,170,915
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top