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:

- Excel Formula in SharePoint Calculated Field/Column
- Calculated column - problem with formula
- Calculated column formula
- How can I build a longer (7>)calculated formula using the =IF function
- Setting the formula of a calculated field using the Object Model
- Using calculated columns in content types
- Using the file namd in a calculated column
- Trying to create a sign-up list using calculated columns
- 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
- Calculating average from column of multiple list
- Calculate column misssing in Total category
- Calculated Counter column in sharepoint list
- Calculated Column for DIF
- Calculated columns
- SPD Workflow - getting calculated value back into list column
- Calculating column values from choice field
- Calculated Column question
- Calculated Column - Need to increment a counter
- Calculated Column - Count Text
- InfoPath and Calculated Columns
- Getting a calculated Column from a list
- Field is not available in selection box for calculated column