Wauvel

Excel like a finance pro.

← The library

Text function

REPLACEB

Replaces part of a text string by byte position, for double-byte languages.

Rarely usedDifficulty 1250 · ProficientUsage rank #286 of 520
Practice · 2 questions →

When to use it

REPLACE by byte position.

The shape of it

Syntax
=REPLACEB(old_text, start_num, num_bytes, new_text)

Worked examples

  • Double-byte

    =REPLACEB("東京都",1,2,"大阪") → 大阪京都

    The first two bytes (one character) replaced.

  • Single-byte

    =REPLACEB("abcdef",2,3,"X") → aXef

    Like REPLACE for single-byte text.

  • Delete bytes

    =REPLACEB("東京都",3,2,"") → 東都

    Removing the middle character.

Worth knowing

  • Use REPLACE unless bytes matter.
  • Pair with FINDB.
  • Odd byte counts can split characters.

Where it goes wrong

  • Like REPLACE on non-DBCS systems.
  • Non-portable.

Related

LEFTRIGHTLENTRIMUPPERLOWER

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.