How to Use REPLACEB() in Google Sheets

Description

Replaces part of a text string, based on a number of bytes, with a different text string..

How To Actually Use REPLACEB() in Sheets

REPLACEB(text, position, num_bytes, new_text)

Try REPLACEB yourself

In cells A1:A5, you have text strings. Use the REPLACEB formula in cell B1 to replace the first 3 bytes of the text in A1 with 'XYZ'. Drag the formula down to fill B2:B5.

Your formula

Hints (3)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for REPLACEB(). Click through to watch.

Browse more tutorials

How to Replace Text with a Blank Cell in Google Sheets

Learn the Quick Fix! Replace Text with Blank Cell in Google Sheets Hassl...

Beginner

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

This is one of the most popular asked first "automations". How to move a...

Add Title Case to Google Sheets

Discover the Ultimate Google Sheets Hack! Transform Text with Title Case...

Advanced

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Unlock these tutorials

Learn more about the REPLACEB() formula:

Generate a REPLACEB() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses REPLACEB(). 2 free AI generations, no signup. Members get unlimited use.

Generate a REPLACEB() formula