Remove first 3 characters

[REGCAST013]

Hello all,

I have a data list that I need to remove the first 3 characters and forgot how to do it.

example
00-exe
10-cdc

result needed
exe
cdc


All start with 2 numbers then a dash that I would like removed.
This should be an easy one for this forum!

Your help is appreciated!

Regina

 

[cjcobra]

This will take everything from the 4th digit to the 10th digit and remove any spaces, in case you need more room.

TRIM(MID(A1,4,10))

 

[Ron Coderre]

Try this:
• Select the single-column range of cells to be impacted
• Data.Text-to-columns
...Check: Fixed_width...Click: Next
...Click between the 3rd and 4th characters to insert a break point
...Click: Next
...Select the first "column"...Click: Skip
...Click: Finish

Does that help?

 

[REGCAST013]

Worked great
Thanks!

 

[stilesbn]

This will take out the first 3 regardless of how many characters there are.

=RIGHT(A2,(LEN(A2)-3))

Of course if there are only ever 3 characters after the dash you could always use =Right(A2,3)

 

[Volar]

I just use ctrl F and replace