=LEFT(A1,7) 'Remove last 3
=RIGHT(A1,7)'Remove First 3
"Mr. Low" wrote:

Dear Sir,

May I know what formula I must input at cell B1 to remove the last 3 and the
first 3 digits of the reference number in column A as illustrated?


1. To remove last 3 digits

A B
Before After
0410003003 0410003
0411923001 0411923
0411924002 0411924


2. To remove first 3 digits

A B
Before After
0409596001 9596001
0409596002 9596002
0409596003 9596003


Thanks

Low




--
A36B58K641