Extraction
 

Dear Experts,
I have one cell which contains the following string of characters exactly in
this format:

Smith, Jane (jc162964) | 0616025915

Can I use excel to extract the last ten digits and put them into another cell
AND
Can I use excel to extract the Smith, Jane part into another cell?
regards
Martina

Extraction
 

To extract the number:

=MID(A1,FIND("|",A1)+2,255)

To extract the name:

=LEFT(A1,FIND("(",A1)-2)

Biff

"Martina" wrote in message
...
Dear Experts,
I have one cell which contains the following string of characters exactly
in
this format:

Smith, Jane (jc162964) | 0616025915

Can I use excel to extract the last ten digits and put them into another
cell
AND
Can I use excel to extract the Smith, Jane part into another cell?
regards
Martina

Extraction
 

To extract the number:
=MID(A1,FIND("|",A1)+2,255)

Or, if the number is *always* 10 digits long:

=RIGHT(A1,10)

Biff

"T. Valko" wrote in message
...
To extract the number:

=MID(A1,FIND("|",A1)+2,255)

To extract the name:

=LEFT(A1,FIND("(",A1)-2)

Biff

"Martina" wrote in message
...
Dear Experts,
I have one cell which contains the following string of characters exactly
in
this format:

Smith, Jane (jc162964) | 0616025915

Can I use excel to extract the last ten digits and put them into another
cell
AND
Can I use excel to extract the Smith, Jane part into another cell?
regards
Martina

Extraction
 

That is fantastic, thank you so much!!
regards
Martina

"T. Valko" wrote:

To extract the number:
=MID(A1,FIND("|",A1)+2,255)

Or, if the number is *always* 10 digits long:

=RIGHT(A1,10)

Biff

"T. Valko" wrote in message
...
To extract the number:

=MID(A1,FIND("|",A1)+2,255)

To extract the name:

=LEFT(A1,FIND("(",A1)-2)

Biff

"Martina" wrote in message
...
Dear Experts,
I have one cell which contains the following string of characters exactly
in
this format:

Smith, Jane (jc162964) | 0616025915

Can I use excel to extract the last ten digits and put them into another
cell
AND
Can I use excel to extract the Smith, Jane part into another cell?
regards
Martina

Extraction
 

You're welcome. Thanks for the feedback!

Biff

"Martina" wrote in message
...
That is fantastic, thank you so much!!
regards
Martina

"T. Valko" wrote:

To extract the number:
=MID(A1,FIND("|",A1)+2,255)

Or, if the number is *always* 10 digits long:

=RIGHT(A1,10)

Biff

"T. Valko" wrote in message
...
To extract the number:

=MID(A1,FIND("|",A1)+2,255)

To extract the name:

=LEFT(A1,FIND("(",A1)-2)

Biff

"Martina" wrote in message
...
Dear Experts,
I have one cell which contains the following string of characters
exactly
in
this format:

Smith, Jane (jc162964) | 0616025915

Can I use excel to extract the last ten digits and put them into
another
cell
AND
Can I use excel to extract the Smith, Jane part into another cell?
regards
Martina