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
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
SORRY
FOR THE ATTACHMENT
ATTACHED FILE
Please don't type with your CAPS on! THis is not the first time that I've asked you about this.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
ok sorry
Well, as long as there's only one colon, have you tried:
=RIGHT(B1,LEN(B1)-FIND(":",B1))