How to remove characters from the right?

K L

I'd like to remove characters from the right. What formula would I use?

Example: Person's Name (FL)

I want to remove the (FL) part and have the cell only reflect the person's name.

Thank you!

Jenna Bailey

=LEFT(CELLREFERENCE, (LEN(CELLREFERENCE) - 5))

for the above just change the cell reference to whatever the cell is

Jenna Bailey

=LEFT(CELLREFERENCE, (LEN(CELLREFERENCE) - 5))

for the above just change the cell reference to whatever the cell is

K L

@Jenna Bailey Wow, thanks for the fast response, this worked perfectly. Thank you!

kgahm7569

Hi -- I'm getting an apostrophe attached to a # when I use this. How do I remove that 'hidden' apostrophe>

damon.tackett

This is great! I am wondering if there is a way to do it where the number of characters is variable? sometimes it may be the 5 but maybe other times it is 10?

Example...the formula above would work for John Jacobs (FL) but from my reading of the explanation if the source was John Jacobs (FL) Tampa I would need to use a formula such as =LEFT(CELLREFERENCE, (LEN(CELLREFERENCE) - 10))

If my source column has variables that I want to remove to leave just the name clean is there a formula that accomplishes that?

Annaleah Morrow

@damon.tackett did you get a response on this one? I also have a variable on the left. Sometimes I have '1d' as my value and sometimes I have '500d' as the value and I just need to remove the d.

Annaleah Morrow

@damon.tackett ignore. I found the answer on

https://community.smartsheet.com/discussion/85177/extract-a-text-string-to-remove-unwanted-text