Function for all Characters after the :

M

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
 
T

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
 
M

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
Click to expand...

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