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
try:
=RIGHT(A2,LEN(A2)-FIND(":",A2)-1)
or
=MID(A2,SEARCH(":",A2)+2,LEN(A2))
Last edited by sandy666; 04-18-2016 at 01:53 PM. Reason: added 2nd formula
Hi TicklyTigger,
The TRIM function didn't work because of the char(160), a non-printing character that is present in the string.
Here is another way to extract part of the string.
Enter in C2 and copy down
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try
=RIGHT(A2,LEN(A2)-FIND(":",A2)-1)
Or
=REPLACE(A2,1,FIND(":",A2)+1,"")
Thanks everyone, this worked: =RIGHT(A2,LEN(A2)-FIND(":",A2)-1)
If anyone has helped you, then thank them by clicking on their reputation star * bottom left then mark thread SOLVED! (Above Your first post --> Thread Tools --> Mark thread as Solved)
yup, done!
really?
If anyone has helped you, then thank them by clicking on their reputation star * bottom left then mark thread SOLVED! (Above Your first post --> Thread Tools --> Mark thread as Solved)
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks