Formatting

[Salamullah]

I have copied data contained 4 columns from Adobe Acrobat Reader into Excel, while pasting into excel its showing all data in single column, please help me to bring data into columns in excel or give other solution.

Adobe Acrobat Reader
Table Name	Description	System	Two-Charater
F00924	User Install Packages	H95	IP
F0093	Library List Control	H99	LL
F0094	Library List Master File	H95	LM
F00941	Environment Detail – OneWorld	H92	LM

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>

Excel

F00924 User Install Packages H95 IP

F0093 Library List Control H99 LL

F0094 Library List Master File H95 LM

F00941 Environment Detail – OneWorld H92 LM

<tbody>
</tbody><colgroup><col></colgroup>

 

[AlanY]

this works on your sample

Excel 2013/2016
	A	B	C	D	E
1	F00924 User Install Packages H95 IP	F00924	User Install Packages	H95	IP
2	F0093 Library List Control H99 LL	F0093	Library List Control	H99	LL
3	F0094 Library List Master File H95 LM	F0094	Library List Master File	H95	LM
4	F00941 Environment Detail OneWorld H92 LM	F00941	Environment Detail OneWorld	H92	LM
Sheet1

Cell Formulas
Range	Formula
B1	=TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",20)),20))
C1	=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,B1,REPT(" ",20)),D1," "),E1," "))
D1	=TRIM(LEFT(RIGHT(SUBSTITUTE(A1," ",REPT(" ",20)),40),20))
E1	=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",20)),20))