Formulas > =RIGHTB()

How to Use RIGHTB() in Google Sheets

Description

Returns the right portion of a string up to a certain number of bytes..

How To Actually Use RIGHTB() in Sheets

RIGHTB(string, num_of_bytes)

Try RIGHTB yourself

In the range A1:A10, use the RIGHTB formula to extract the last 5 bytes from each string. Your formula should be placed in cell B1 and dragged down to B10.

Hints (2)

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 RIGHTB(). Click through to watch.

Watch more tutorials
Calculate ROAS in Google Sheets

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Learn more about the RIGHTB() formula:

Generate a RIGHTB() formula for your needs

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

Generate a RIGHTB() formula
Ads keep the free stuff free. Members browse ad-free — log in or see pricing.
Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.