Retrieving String after specific character

[TicklyTigger]

Hi,

I have a table with bank transactions (column A), where the description includes the budget it's allocated to. I found a formula that retrieves the characters after a particular character (a : in this case), but for some reason, it still includes a space before the resulting title (see column C).

I tried using the TRIM function, but that doesn't do anything.

Any ideas? See the attachment for a sample!

Many thanks!

TT