ignore first 2 characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there anyway to format a cell so that it trims off the first 2 characters
of the cell. For example my cell contains a query that shows PR101 or PL101.
Is there a way to make it just show 101. For this application the PL and PR
don't matter. Am I out of luck on this one or can it be done. Thanks.
 
got to make a new column (if your #'s are in A, here's the function in B)

= Right(A1,Len(a1)-2)

HTH


*** you aren't related to Jason Sneed (in charlotte)are you?
 
Thank you. And no i don't think i am related to Jason. From what i know, i
believe almost all my family is Oklahoma.
 
You must log in or register to reply here.

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

Cell limit of characters 4
Formula to validate characters within a string of data in aparticular cell 1
Indent based on character length 4
Excel Concatenate with line breaks but ignore blank cells 3
Count specific characters in a cell 7
Re: Formula to Remove Special Characters 5
Extract first numeric characters only??... 7
Trimming a cell down to 256 Characters 2

Back
Top