Search: | |||||

| ||||

Home » Forum » Sharepoint | RSS Feeds |

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.

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

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

Related Topics:

- Calculated column formula
- Excel Formula in SharePoint Calculated Field/Column
- Calculated column - problem with formula
- Setting the formula of a calculated field using the Object Model
- How can I build a longer (7>)calculated formula using the =IF function
- Using the file namd in a calculated column
- Trying to create a sign-up list using calculated columns
- Using calculated columns in content types
- Column IF formulas only nest seven deep.
- Using formulas in sharepoint
- Using a parent site data column within a subsite column
- Using data from column of parent site as column in sub-site project
- Calculated Columns in Lists
- Calculated Column Output HTML
- Calculated Column Begin Event List
- Item ID in Calculated Columns
- Problems searching in a calculated column in a data view web part
- Calculated column problem
- More on calculated columns
- How do I calculate column averages?
- Calculated Fields and the ID Column
- Calculated Column Formatting
- Date Operators for calculated fields in list columns
- WSS V2 Calculated Column
- MOSS, moss 2007, search scope with a calculated site column