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!

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

Formula

Status
Not open for further replies.

dwayne94

Programmer
Aug 14, 2007
21
US
How to create a formula in Excel that will give me certain characters? For instance if I have the city Alpharetta and I want to see the last 6 characters only how would I wirte the formula?
 
=right(A1, 6)

If there are other requirements, you'll need to specify them for us to come up with a formula.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top