Revome first character

[sabetik]

Is there a function to remove the first character from a cell ex:

E76851-52060-C1 to show 76851-52060-C1

E61612-48041 show 61612-48041

Thanks

 

[sabetik]

Sorry in Excel

 

[Fenrirshowl]

Yep. If the text is in A1 then =Right(A1,Len(A1)-1) should do it. Len gives the length of the string and Right shows only the given number of characters from the far right of the string.

 

[KenWright]

Easiest way might well be to simply use Data / Text To Columns / Fixed Width, insert a break after the first character and then choose 'Do Not Import' on the first column.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------