How to open delimited delimiter file in Microsoft Excel?

Question

When I try to open a space delimited file in excel, all the content opens in a single column. Is there a way to open space delimited file in excel so that delimited content is correctly formatted into different columns?

My scenario is that I have a file that needs a delimiter to be something like "" (an inverted command followed by a space), because my file format is as follows:

"First Name" "Gender" "Phone" "Tom Jones" "M" "123-123-1234" 

Answer 1

Use the standard Open command. Then go to the “Text Import Wizard” and select so that the original data type is limited. You may need to go to another step of the wizard to indicate that the separator is space, but the wizard includes the option of indicating which character is the separator.

Answer 2

On the Data tab, click From Text in the Get External Data section.

Ask the wizard to use a space as a separator.

Answer 3

For Excel on Mac, I had to:

• Select column
• Data → Text to Columns
• Choose a separator
• Choose a separator

Answer 4

It is crazy that such a simple task is so complex. Use Google docs, it will recognize the format and return the copies.