Tag Archives: part of string

Extracting Part Of A String

The functions, Left, Right, and Mid allow you to extract part of a cell’s entry. If cell A1 contains “ABC567DEF, then Left(Range(“A1”).Value, 3) returns “ABC” Mid(Range(“A1”).Value, 3) returns C567DEF Mid(Range(“A1”).Value, 4, 2) returns just “56”, a text string. To convert it to a number use Val(any string). Right(Range(“A1”).Value, 2) returns “EF” Mid() function The Mid() […]