Extracting certain data from excel 2

[sap1958]

Edit 1 ESC 1 Provider Cerificaton

I want to exclude the Edit 1 ESC. I want to show the following in separate columns:

Code Reason
1 Provider Certification

I am thinking I need a right(len) statement of some type. Any ideas??

 

[randy700]

How about? If [blue]Edit 1 ESC 1 Provider Cerificaton[/blue] is in cell A2:

=mid(A2,12,1)
=right(A2,Len(A2)-14)

Randy

 

[SkipVought]

hi,

just ONE cell or a bunch in a column?

same values to remove (Edit 1 ESC) or different?

another option could be Data > Text to columns -- FIXED WIDTH.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}