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

Problems with my label templates 0
Cumulative formula for word table 0
Centered text that does not stay centered 0
Need help finding old, outdated contacts in Outlook 365 on my PC 0
Using FIND to highlight text (with dashes) 4
Creating a Chart on form from selected data in query. 0
No text box in word 2016 0
Creating a Search using a combo box and then creating a report. 4

Top