Importing a number and not the percent symbol

Excel Help for Importing A Number And Not The Percent Symbol in Developing Business Administration Solutions

Importing A Number And Not The Percent Symbol

Rate this: (4/5 from 2 votes)

	Hi Thanks a lot for this great tool. it works like a charm. Only one thing I am not having any luck with. I have a number displayed as a percentage in the pdf document and I only want to import the number as is, but not the percentage symbol. I would appreciate any help on how to do this. Here is an example: in the pdf I have this line: Making up a number 0.5 %   10.0 % I used the following to import the numbers: Start Text     End Text      Replacement Pairs number        %*              number,|% When I 'Run Extraction' I get the following output: 0.5      10.0 so my question is how do I get the program to only return the number 0.5 and not the 10.0 Thanks
	Posted by bunjaby on 09 May 2014

View Full Post