Power Query
published
Search
⌃K

Text.RemoveRange

Text.RemoveRange

Removes a count of characters starting at the given offset
function (optional text as nullable any, offset as number, optional count as nullable any) as nullable any

Description

Returns a copy of the text value text with all the characters from position offset removed. An optional parameter, count can by used to specify the number of characters to remove. The default value of count is 1. Position values start at 0.

Category

Text.Modification

Examples

Remove 1 character from the text value "ABEFC" at position 2.
Text.RemoveRange("ABEFC", 2)
"ABFC"
Remove two characters from the text value "ABEFC" starting at position 2.
Text.RemoveRange("ABEFC", 2, 2)
"ABC"