Splitting the contents of a cell?
For 3001001E:Name in Cell A1
B1: =RIGHT(A1,LEN(A1)-(SEARCH(":",A1)))
Does that help?
***********
Regards,
Ron
"Dan B" wrote:
Hi,
I have several columns of data that contain data such as:3001001E:Name
I want to keep what is on the right side of the colon. How could I do this
with a function?
Thanks.
|