Column Breaks

  • Thread starter Thread starter Ams
  • Start date Start date
A

Ams

Dear All Excel Experts

Is it possible to open text file in Excel and split using Text Import
Wizard as per Required column breaks


Please Suggest
 
Use the 'Data, Text to Columns' option on the standard toolbar.

If all the text is in column A, highlight the column first by clicking on
the column heading.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text To Column max 26 characters 7
Split Text in a Cell (4 columns) 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Extracting a number from a multiline-entry 9
Replace manual line breaks (Alt+Enter) with two spaces for selectedcells 5
When importing text field Excel chops off leading spaces 1
update links in Word from Excel 1
Split column contents (de-concantenate) 7

Back
Top