Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I trim the first x characters from a string?

Status
Not open for further replies.
matpj

matpj

Technical User
Mar 28, 2001
687
GB
I have a column containing a string of charactes that includes project code and project name.
If I create a new column, what formula can I use to trim the first 8 characters from this?

thanks,
Matt
 
Sort by date Sort by votes
What about ..

[blue][tt] =RIGHT(A1,LEN(A1)-8)[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.
 
Upvote 0 Downvote
very good thinking.
thanks for that!!
:)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
How can i have more than 1 line in the body of an email
Replies
2
Views
361
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
343
Andrzejek
Andrzejek
S
  • Locked
  • Question
MS Project - how to add a new task into an existing baseline
Replies
0
Views
205
selazar
S
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
2K
Andrzejek
Andrzejek
jlr123
  • Locked
  • Question
Highlight (any) first text word that is a duplicate
Replies
2
Views
383
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top