Hi All
I'm working on a long list of client records - all very old.
Historically, when staff recorded in this list they had to add a fee earner's initials after the client name. Now I need to cut these initials from the fields and move them to another column.
The initials are always put in (brackets) after the clients name, and are usually 3 character long: (ZZZ).
The extracting and moving the initials went very well (using =Right(Text,5) into new column) but now I need to delete these from the end of each record.
I've found a useful way in this post which I had great hopes for: http://chandoo.org/wp/2010/01/19/usernames-from-email-formulas/
So I went ahead applying the formula to my sheet... However, the tricky obstacle is that the character I need to use to mark the point of trimming (like the "@" in the example in the above post) is actually a (...
I cannot enter "(" into the formula - it just cries out for a closing bracket and giving me all kinds of grief.
Any ideas?
Thank you,
K.
I'm working on a long list of client records - all very old.
Historically, when staff recorded in this list they had to add a fee earner's initials after the client name. Now I need to cut these initials from the fields and move them to another column.
The initials are always put in (brackets) after the clients name, and are usually 3 character long: (ZZZ).
The extracting and moving the initials went very well (using =Right(Text,5) into new column) but now I need to delete these from the end of each record.
I've found a useful way in this post which I had great hopes for: http://chandoo.org/wp/2010/01/19/usernames-from-email-formulas/
So I went ahead applying the formula to my sheet... However, the tricky obstacle is that the character I need to use to mark the point of trimming (like the "@" in the example in the above post) is actually a (...
I cannot enter "(" into the formula - it just cries out for a closing bracket and giving me all kinds of grief.
Any ideas?
Thank you,
K.