Click Ok, a dialog popped out for you to select a cell to put out the result.Ħ. Here, my data is in three columns, I type 3 into it. Then in the Transform Range dialog, check Single column to range option, and go down to check Fixed value, and type the number of columns you need in the next text box. Now click Kutools > Range > Transform Range.
Then change the row to a column with copying the row by pressing Ctrl + C, next right clicking a blank cell and selecting Paste Special > Transpose (T).ģ. In this condition, select this cell, and click the Data > Text to Columns > Delimited to split the cell to a row. Tip: Sometimes in windows 8 system, the table may be pasted into one cell. Then apply Excel, and select a blank cell, here I select A1, and press Ctrl + V to paste it. Select the table in the PDF you want to convert to Excel, and then press Ctrl + C to copy it. Get it Now Kutools for Excel, with more than 300 handy functions, makes your jobs more easier.Īfter installing Kutools for Excel, please do as below: （Free Download Kutools for Excel Now!)ġ. Free to try with no limitation in 30 days. Kutools for Excel includes more than 300 handy Excel tools. With Kutools for Excel’s Transform Range feature, you can quickly transform the pasted data into the correct column format. Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.Ĭonvert PDF to Excel with Kutools for Excel’s Transform Range Kutools for Excel augments Excel with Export Range to File utility for Excel users who want to quickly process the following operations： Click for 30-day full featured free trial! If you want to save a range of data as a CSV or workbook in Excel, you may need to use a VBA Macro for doing this or to copy the range to clipboard and paste it in a new workbook and then save the workbook as CSV or Workbook. Normally, Excel does not support you with an option to quickly export or save a range as a CSV or Excel file. Quickly convert or export a range of a sheet to separate XLS/Word/PDF or other format files in once time
0 kommentar(er)
