Extracting all text from a cell to the right of a symbol

wonga09

Hi, I'm trying to extract all text from a cell after the hyphen "-" symbol. There may be a long text string after the hyphen, not a set number of characters. I can get it to extract words to the left of the hyphen using the LEFT function but when I try to use RIGHT it cuts off part of the text?

Top row formula in Short Comment column: =LEFT(Comment@row, (FIND("-", Comment@row)))

Second row formula in Short comment column: =RIGHT(Comment@row, (FIND("-", Comment@row)))

Kerry St. Thomas

Your solution is MID - like LEFT, this function counts starting at the beginning of the string - which is where you need to start counting, since you don't know how long an entry will be.

=MID(Comment@row,FIND("-",Comment@row,1)+1,4000)

The ,1 in the formula locates the leftmost hyphen - I just like that kind of precision. The +1 in the formula extracts starting the character after the hyphen. The 4000 in the formula extracts up to the 4000 characters after that hyphen - so since there's a max of 4000 characters allowed per cell, you won't risk pulling just the middle characters of a cell.

Good luck!

Kerry St. Thomas

Your solution is MID - like LEFT, this function counts starting at the beginning of the string - which is where you need to start counting, since you don't know how long an entry will be.

=MID(Comment@row,FIND("-",Comment@row,1)+1,4000)

The ,1 in the formula locates the leftmost hyphen - I just like that kind of precision. The +1 in the formula extracts starting the character after the hyphen. The 4000 in the formula extracts up to the 4000 characters after that hyphen - so since there's a max of 4000 characters allowed per cell, you won't risk pulling just the middle characters of a cell.

Good luck!

wonga09

Thank you so much Kerry!