Removing part of a text string

[wisemank]

68049806AA CAP&MOUNT RING ASSY BATTERY

That is an example of many rows of data. I need to remove the first 10 characters and leave only the Text. Any ideas.....

 

[Trebor76]

Hi there,

Here's one possibility (just change the location of the source cell [A2] and copy down to suit):

=MID(A2,12,LEN(A2)-11)

Regards,

Robert

 

[Warship]

=right(a1,len(a1)-10)

 

[Haseeb Avarakkan]

Or,

=TRIM(REPLACE(A2,1,10,""))

 

[wisemank]

That did it......33000 lines fixed in two minutes!