Pull Left & Right Text

A

almostwrite

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

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

myText = "Hello World"
rText = Right(myText, 5) 'Returns "World"
lText = Left(myText, 5) 'Returns "Hello"
mText = Mid(myText, 6, 6) 'Returns " World"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to delete first n chars 3
Pulling text from the right end of a string 6
Question on Removing Characters 13
correct syntax for LEFT in vba 3
FORMULA TO MINUS TEXT CHARACTERS 3
IF(AND(Complex Formula in Error in data import before I process it 8
Bold items within text string 7
Oversensitive touchpad on modern laptops 0

Top