← 개발일지

Excel Add Prefix to Column: 3 Easy Methods

exceldata-cleaningproductivityautomation

Adding a prefix to every value in an Excel column is a common data-cleaning task.
For example: turning A123 into USER_A123.

This guide explains three practical ways to add a prefix in Excel, with trade-offs.

1. Use a Formula (Best Practice)

="ABC_" & A1

Why this works best

  • Keeps original data intact
  • Easy to verify before applying
  • Fully reproducible

Workflow

  1. Apply formula in a new column
  2. Review results
  3. Paste values over original column

2. Flash Fill (Fast but Less Reliable)

Steps

  1. Manually type the first result
  2. Press Ctrl + E

Notes

  • Excel detects patterns automatically
  • Can fail with inconsistent data

3. Find & Replace Trick (Fastest)

Steps

  1. Press Ctrl + H
  2. Leave Find empty
  3. Enter "ABC_" in Replace

How it works

  • Replaces empty string with prefix

Risks

  • Affects blank cells too
  • Hard to undo
  • Can corrupt data

Which Method Should You Use?

  • Data matters → Formula
  • Speed matters → Replace
  • Simple patterns → Flash Fill

Key Takeaway

Always follow this workflow when transforming data:

Preserve → Transform → Validate → Overwrite

This pattern prevents most data-related mistakes.