Skip to main content

fn_replace

Function fn_replace 

Source
pub fn fn_replace(args: &[Expr], ctx: &mut Evaluator<'_>) -> Result<CellValue>
Expand description

REPLACE(old_text, start_num, num_chars, new_text) - replaces by position.

Both numbers are truncated toward zero. A start outside 1..=32767 or a length outside 0..=32767 returns #VALUE!, as in Excel.