Forum Discussion

KaisaJanzen's avatar
KaisaJanzen
Qrew Cadet
9 years ago

Formula To Truncate Text Field

I need to write a formula for a text field titled "subject" that consistently removes the text "Confirmation Copy of Welcome Letter sent to" from the subject heading "Confirmation Copy of Welcome L...
KaisaJanzen's avatar
KaisaJanzen
Qrew Cadet
9 years ago
Right(Trim([Subject])," ") works beautifully!  May I ask how this formula tells QB to trim at the termination of "Confirmation Copy of Welcome Letter sent to" so I can use it again for other formula fields?

THANKS!