Function for all Characters after the :

[mcbe]

I need a formuls that will take all of the Characters after a colon in
a cell.
I Have:
B3 = LastName : Jones
B4 = LastName : Anderson
I need:
R3 = Jones
R4 = Anderson

Thanks in advance for the help.
Mike3108

 

[Dave Peterson]

=TRIM(MID(A1,SEARCH(":",A1)+1,LEN(A1)))

Is one way.

 

[T. Valko]

Try this:

=MID(B3,FIND(":",B3)+2,255)

Copied down as needed.

It appears that your second example has a double space after the ":". If the
number of spaces is variable try this version:

=TRIM(MID(B3,FIND(":",B3)+1,255))

Biff

 

[mcbe]

I need a formuls that will take all of the Characters after a colon in
a cell.
I Have:
B3 = LastName : Jones
B4 = LastName : Anderson
I need:
R3 = Jones
R4 = Anderson

Thanks in advance for the help.
Mike3108

Thank you to Dave Peterson and T. Valko.
I tried all 3 equations and they all seem to work GREAT.
Thanks Again.

 

[Guest]

=RIGHT(B3,LEN(B3)-FIND(":",B3)-1)