Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Calculated Column using =LEFT() formula

Asked By: Anthony Veracruz Date: Sep 15, 2010 Category: Sharepoint Views: 4577

Hello.

I have a list column with a single line of text in the following format:

Entity Name - 123 Anystreet Dr., Yourcity, ST 12345

I found a formula example on another site that was designed to remove the first section of the string, and have applied it to my column. It works, and removes the Entity Name, just leaving the address. However, I need exactly the opposite of this. I need to strip out the address, and only have the Entity Name in the calculated column. I don't understand enough about what is happening in this formula to know how to fix it. Here is what I am using:

=LEFT(RIGHT(Location,((LEN(Location)-FIND("- ",Location)))),LEN(Location)-FIND("- ",Location)-1)

I appreciate any help anyone can provide.

Tagged:calculated column using left formula

2 Answers Found

Answer #1 Answered By: Peter paul Kirschner Answered On: Sep 16, 2010

I hope i have the right Solution for you

=LEFT(RIGHT(Location,((LEN(Location)-FIND("- ",Location)))),LEN(Location)-FIND("- ",Location)-1)

Result= 123 Anystreet Dr., Yourcity, ST 1234

=Right(Location,(LEN(Location)-FIND("- ",Location)))

Result =123 Anystreet Dr., Yourcity, ST 12345

=Left(Location,FIND("- ",Location))

Result= Entity Name -

=Left(Location,FIND("- ",Location)-2)

Result= Entity Name

I hope this will help you

Answer #2 Answered By: Nursultan Tulyakbay Answered On: Apr 29, 2012

@ Peter Paul Kirsher

All of the formulas result in error --> "The formula contains a syntax error or is not supported."

I didn't copy and paste the formulas.

Didn't find what you were looking for? Find more on Calculated Column using =LEFT() formula Or get search suggestion and latest updates.