Trip expenses often arrive as a few sentences in an email: who went where, when, and how much it cost. Paste that into Excel and the whole thing lands in cell A1. Splitting it by hand means retyping every value.
TL;DR: Ask ChatGPT to turn the text into a table with the columns you name, copy the answer, and paste it into A1. Each value gets its own cell.
Steps
- Paste the text into ChatGPT and add one line (translated): Put the content below into a table. Columns, in order: name, department, destination, departure date, expenses (KRW).
- Press Enter and use the copy button under the answer.
- Click A1 in Excel and paste.
Name through expenses go into separate columns, and the expense values arrive as numbers, so you can calculate with them right away.
The total row is not a formula
ChatGPT sometimes adds a total row on its own. That row is a typed number, not a formula. If someone later corrects one expense, the total will be wrong and nothing will warn you.
Click the total cell and press Alt+=. Excel inserts a SUM over the column above, and from then on the total follows any edit.
In my test, four people's trip notes became a five-column table in about four seconds. The total was 497,000 KRW before and after switching to the Alt+= formula.
Naming the columns is the real trick
Listing the columns fixes both the headers and their order. That matters when the table has to sit under last month's rows: the new data lines up without rearranging anything.
Written with AI assistance. The steps were tested by hand before publishing.
Top comments (0)