<div>
Hi,<br />
<br />
In Excel you can import the text file and then use the 'Text to columns' &nbsp;function:<br />
<br />
1. On the Data tab<br />
2. Click on Get External Data from Text<br />
3. Select your text file<br />
4. Select Delimited, Next<br />
5. Deselect all other options and select 'Other' and type '=' (without the quotes)<br />
6. Click Finish<br />
<br />
Nou you should have your data split in two columns.
</div>


Hi,

In Excel you can import the text file and then use the 'Text to columns'  function:

1. On the Data tab
2. Click on Get External Data from Text
3. Select your text file
4. Select Delimited, Next
5. Deselect all other options and select 'Other' and type '=' (without the quotes)
6. Click Finish

Nou you should have your data split in two columns.

<div>
If your data is already in Excel, then you can split it on the equals sign using the Data...Text to Columns menu item. You want to specify Delimited in the first step of the wizard and choose Other with = in the second step.
</div>


If your data is already in Excel, then you can split it on the equals sign using the Data...Text to Columns menu item. You want to specify Delimited in the first step of the wizard and choose Other with = in the second step.

text-to-column.xlsx

<div>
<div class="content wysiwyg-content">
I have a txt file with entries with lines in the format:<br />
<br />
Name=Value<br />
eg.<br />
error.booking.wrong-cc=You<wbr /> entered an invalid credit card number. Please enter a valid one.<br />
<br />
<br />
It was nearly four hundred lines like this and I was hoping there was a way to automate the entry of this data into a two column excel spreadsheet. There the equal sign is would begin the second column.<br />
<br />
Does anyone know how this could be done?
</div>
</div>


I have a txt file with entries with lines in the format:

Name=Value
eg.
error.booking.wrong-cc=You entered an invalid credit card number. Please enter a valid one.


It was nearly four hundred lines like this and I was hoping there was a way to automate the entry of this data into a two column excel spreadsheet. There the equal sign is would begin the second column.

Does anyone know how this could be done?

Aumatic data entry in Excel for Key Value Pairs

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.