Macro to convert PDF to Excel Data to Excel Format

H

hiker95

Well-known Member

Joined

Apr 8, 2009

Messages

17,648

• May 23, 2009

• #2

Vgabond,

Try:
Converting an Adobe file into Excel
http://www.nuance.com/pdfconverter/converter/

 

Upvote 0

Vgabond

Board Regular

Joined

Jul 22, 2008

Messages

191

• May 23, 2009

• #3

hiker95 said:

Vgabond,

Try:
Converting an Adobe file into Excel
http://www.nuance.com/pdfconverter/converter/

Click to expand...

Hi Hiker

I don't have any problem to convert PDF to Excel since I've already have the converter. My issue is if there's Macro that can be use to replace F2 ENTER in order for the data to be recognize by Excel.

 

Upvote 0

W

wsjackman

Well-known Member

Joined

Jun 19, 2008

Messages

2,465

• May 23, 2009

• #4

try
enter 1 in an empty cell
copy this cell
select the data to be converted
paste special multiply

 

Upvote 0

xenou

MrExcel MVP

Joined

Mar 2, 2007

Messages

16,836

Office Version

1. 2019

Platform

1. Windows

• May 23, 2009

• #5

That's a nice trick - would work for numeric data i presume, does it work with formulas? Would add a =(XXXX)*1 to everything I presume?

Another one is to use find and replace, finding the equals signs and replacing them with new equals signs.

-------------------
Find:
=

Replace with:
=
-------------------

 

Upvote 0

Vgabond

Board Regular

Joined

Jul 22, 2008

Messages

191

• May 23, 2009

• #6

wsjackman said:

try
enter 1 in an empty cell
copy this cell
select the data to be converted
paste special multiply

Click to expand...

Hi Jack

Have tried that it won't work....

 

Upvote 0

xenou

MrExcel MVP

Joined

Mar 2, 2007

Messages

16,836

Office Version

1. 2019

Platform

1. Windows

• May 23, 2009

• #7

See my post above too for another try. If it still doesn't work,

convert the data to excel format.

Click to expand...

What is this data like and how is it being converted? (Sample before and after, maybe?)

 

Upvote 0

W

wsjackman

Well-known Member

Joined

Jun 19, 2008

Messages

2,465

• May 23, 2009

• #8

have you tried
select one column at a time
data-text to column-delimited / select space / format general if it shows morem than one column to be transfered check the unwanted column as to not be imported

 

Upvote 0

Vgabond

Board Regular

Joined

Jul 22, 2008

Messages

191

• May 23, 2009

• #9

wsjackman said:

try
enter 1 in an empty cell
copy this cell
select the data to be converted
paste special multiply

Click to expand...

Hi Jack

Sorry..just now I did it wrongly. Anyway it's work but it just on the column that doesn't have any data , it will turn out to be 0. Is there anyway to fix that ??

 

Upvote 0

W

wsjackman

Well-known Member

Joined

Jun 19, 2008

Messages

2,465

• May 23, 2009

• #10

as you can tell by the different methods people are suggesting, this is a common problem and is not always solved by the same method

another method is to goto an empty column
=value(trim(a1))

you can also check
=len(A1) before and after F2-enter
and =len(trim(A1))

I have had to look at
=code(mid(a1,1))
=code mid(A1,2))
etc
until I find a non numeric code and then use replace that with null

 

Upvote 0