Extracting Characters from a Cell...

[Nuyorican]

Good Afternoon All...

I have a column with names and SSN's, as such

John Doe: XXX-23-6789...I want to extract "XXX -" and be left with "John Doe: 23-6789".

Thank you kindly
Benny Torres

 

[NARAYANK991]

Hi ,

If by extract , you mean you want to remove those characters , then you can use the SUBSTITUTE function , as follows :

=SUBSTITUTE(A2, "XXX-", "")

Enter this in any unused column , say G2 ; this will then display John Doe: 23-6789.

 

[Nuyorican]

...My mistake...I did not mean to imply that parentheses were part of the characters in the string, I just used them as an emphasis. So, column reads John Doe: XXX-23-6789 and I want to be left with John Doe: 23-6789.

Thanks

 

[NARAYANK991]

Hi ,

Please see my earlier post.

 

[Nuyorican]

...I'm still left with the same result. Am I missing something ?

 

[NARAYANK991]

Hi ,

As I have understood you , you have the following text in one cell , say A2 :

John Doe: XXX-23-6789

You want the highlighted text to be removed ; if you want this to be done in situ , in the same cell A2 , then you will need to use VBA.

If you don't mind the output in a different cell , you can use the following formula in that cell :

=SUBSTITUTE(A2, "XXX-", "")

This will leave the following text in that cell , where this formula has been entered :

John Doe: 23-6789

Is this what you wanted ? If not , please give more details and post a few worked out examples of both input and output.

 

[Nuyorican]

Thank you !!! The column I had was part of another formula, obviously creating a conflict. I copied the column and pasted to a different sheet with the values only. Everything is fine. I appreciate your patience and help.

Thanks again.