Macro to convert PDF to Excel Data to Excel Format

[Vgabond]

Hi Guys

Is there any macro that can be used to convert data which have been converted from PDF to Excel. Currently I'm using a traditional way by pressing F2 and enter to convert the data to excel format. It's tedious ( since the data range is quite big) and crammed my finger . Can anyone help pretty pls..??

 

[Vgabond]

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

Hi Jack

I guess the 0 on the blank column is small issue. I can fix it by just highlight it all and delete it . Anyway thank you very much for your help. Really appreciate it.

 

[wsjackman]

that should have been code(mid(a1,1,1)) etc.

the fact that you can do the f2 enter indicates you can should be able to find something which will work.

 

[Vgabond]

that should have been code(mid(a1,1,1)) etc.

the fact that you can do the f2 enter indicates you can should be able to find something which will work.

Sure Jack. Anyway thanks again tho. U already make my live easier with your help...