right/left function
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: right/left function

  1. #1
    Guest

    Default

     
    I need a formula to cut the first X characters from the left and the last Y characters from the right of a text string. Anyone know how to do this? Thanks in advance.

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do you want the result to look? Will it be two text strings or do you want to concatenate them into one string? Or are these actually text representations of numbers you will want to be formatted as numbers?

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-03-12 12:42, Anonymous wrote:
    I need a formula to cut the first X characters from the left and the last Y characters from the right of a text string. Anyone know how to do this? Thanks in advance.
    For a value in cell A1...

    =LEFT(RIGHT(A1,LEN(A1)-X),LEN(A1)-X-Y)

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com