Can I Spreadsheet?
← All functions

REPLACE

Supported, behaves as documented

Category: Text · Last tested 2026-08-06

Real, executed compatibility results for the REPLACE function across Microsoft Excel, Google Sheets, and LibreOffice Calc — verified by actually running it. Syntax and links to each vendor’s official documentation are below.

Support matrix

EngineDocumentedLive-testedVerdict
Excel Yes Not yet n/a
Google Sheets Yes Not yet n/a
LibreOffice Calc Yes Yes (25.8.7.3, 2026-08-06) Supported, behaves as documented

LibreOffice version history

We executed the same test cases under each LibreOffice release to show exactly when REPLACE’s support changed — not documentation claims, real results.

LibreOffice versionVerdictTested
24.2.0.3 Supported, behaves as documented 2026-07-19
24.8.7.2 Supported, behaves as documented 2026-07-19
25.2.0.3 Supported, behaves as documented 2026-07-24
25.8.7.3 Supported, behaves as documented 2026-08-06

Executed test cases

LibreOffice Calc 25.8.7.3 (tested 2026-08-06)

FormulaDescriptionResultExpectedVerdict
=REPLACE("123456",1,3,"@") Replaces the first 3 characters by position, regardless of what they are @456 @456 Matched
=REPLACE("2009",3,2,"10") Replaces characters at fixed positions 3-4 2010 2010 Matched
=REPLACE("banana",2,3,"XYZ") REPLACE targets characters purely by position (start_num/num_chars), unlike SUBSTITUTE which matches by content: here characters 2-4 ('ana') are removed and replaced with 'XYZ' regardless of what they spell bXYZna bXYZna
'banana' = b(1)a(2)n(3)a(4)n(5)a(6); removing positions 2-4 ('ana') and inserting 'XYZ' gives 'b' + 'XYZ' + 'na' = 'bXYZna'		 Matched
=REPLACE("abcdefghijk",6,5,"*") Replaces a 5-character mid-string range (positions 6-10) with a single character abcde*k abcde*k Matched

Docs & syntax

Compared against other functions