Post

3 followers Follow
0
Avatar

Removing characters from text

Hi, 

Im trying to remove the last 14 characters from a textstring - but nothing seems to work. 

Which formula do I need to use to do this? 

 

Thomas

Thomas Renneberg

Please sign in to leave a comment.

2 comments

0
Avatar

Hello Rainer,

Thanks! It works :)

The string is actually build lige this: Text1 + Text2 + Text3.

Is it possible to identify the second spacing from the right in order only have text1 as a result?

Text1 could consist of more than one word ex. Office Supplies for Office 1 (text1) + RLK (text2, department) + 2610 (internal ref. number). In this case I only need text1 shown in the calculation field.

Thanks for the help.

 

Thomas Renneberg 0 votes