A almostwrite Sep 30, 2008 #1 This is probably very simple, but I need the formula for pulling characters from the left and right of a text string. Thanks!
This is probably very simple, but I need the formula for pulling characters from the left and right of a text string. Thanks!
D dksaluki Sep 30, 2008 #2 This is probably very simple, but I need the formula for pulling characters from the left and right of a text string. Thanks! Click to expand... Look into MID() or RIGHT() or the LEFT() functions. RIGHT("string",4) would result in "ring" Is that what you mean?
This is probably very simple, but I need the formula for pulling characters from the left and right of a text string. Thanks! Click to expand... Look into MID() or RIGHT() or the LEFT() functions. RIGHT("string",4) would result in "ring" Is that what you mean?
J JLGWhiz Sep 30, 2008 #3 myText = "Hello World" rText = Right(myText, 5) 'Returns "World" lText = Left(myText, 5) 'Returns "Hello" mText = Mid(myText, 6, 6) 'Returns " World"
myText = "Hello World" rText = Right(myText, 5) 'Returns "World" lText = Left(myText, 5) 'Returns "Hello" mText = Mid(myText, 6, 6) 'Returns " World"
