PDA

View Full Version : COPY FROM CELL



oleg_v
03-16-2010, 01:53 AM
Hello

i need some help with formula
i need to copy data from the cell "B1" every thing that on the right of ":"
the answer from the cell "B1" is JACOB and paste it in the the same sheet no differant in wich cell

attached the file

thanks

oleg_v
03-16-2010, 02:21 AM
SORRY

FOR THE ATTACHMENT
ATTACHED FILE

Aussiebear
03-16-2010, 02:57 AM
Please don't type with your CAPS on! THis is not the first time that I've asked you about this.

oleg_v
03-16-2010, 03:11 AM
ok sorry

GTO
03-16-2010, 03:23 AM
Well, as long as there's only one colon, have you tried:

=RIGHT(B1,LEN(B1)-FIND(":",B1))