Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Calculated Column using =LEFT() formula

  Asked By: Anthony    Date: Sep 15    Category: Sharepoint    Views: 21177


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.



2 Answers Found

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

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

@ 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.