Dragging from PDF

inigma_

New Member
Joined
Jan 14, 2010
Messages
5
Hi hopefully an easy one...

I have never seen this before, my colleague is dragging data from a PDF to Excel. If the data was 51,201,145.89 rather than drap it in to 1 cell it breaks it in to 3 cells:

51, 201, 145.89

On my machine it just puts the whole number into 1 cell, is there a setup issue with his Excel that I can modify so he can drag said data in to 1 cell?

Thanks,
T
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
In Data|Text To Columns, check Delimited at Step 1 and make sure that the comma is unchecked at Step 2.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,979
Messages
5,526,024
Members
409,677
Latest member
ssh99

This Week's Hot Topics

Top