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.



[TABLE="width: 548"]
<tbody>[TR]
[TD="align: left"]Adobe Acrobat Reader[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Table Name[/TD]
[TD="align: left"]Description[/TD]
[TD="align: left"]System[/TD]
[TD="align: left"]Two-Charater[/TD]
[/TR]
[TR]
[TD="align: left"]F00924[/TD]
[TD="align: left"]User Install Packages[/TD]
[TD="align: left"]H95[/TD]
[TD="align: left"]IP[/TD]
[/TR]
[TR]
[TD="align: left"]F0093[/TD]
[TD="align: left"]Library List Control[/TD]
[TD="align: left"]H99[/TD]
[TD="align: left"]LL[/TD]
[/TR]
[TR]
[TD="align: left"]F0094[/TD]
[TD="align: left"]Library List Master File[/TD]
[TD="align: left"]H95[/TD]
[TD="align: left"]LM[/TD]
[/TR]
[TR]
[TD="align: left"]F00941[/TD]
[TD="align: left"]Environment Detail – OneWorld[/TD]
[TD="align: left"]H92[/TD]
[TD="align: left"]LM[/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]


Excel
[TABLE="width: 558"]
<tbody>[TR]
[TD="align: left"]F00924 User Install Packages H95 IP[/TD]
[/TR]
[TR]
[TD="align: left"]F0093 Library List Control H99 LL[/TD]
[/TR]
[TR]
[TD="align: left"]F0094 Library List Master File H95 LM[/TD]
[/TR]
[TR]
[TD="align: left"]F00941 Environment Detail – OneWorld H92 LM[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[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))