Obtaining Last Six Digits in A Cell

**Rasputin24** · 11-24-2014, 03:26 PM

Hello,

I have a document which has certain texts in E cell. It starts from E3 but the ending cell depends on my main document size. (could be 10,800,1000 etc.)

Is there anyway to get only the last 6 characters from this string and copy paste the same column that has the long string so I the column only shows 6 characters?

Thank you

Ras

**JOHN H. DAVIS** · 11-24-2014, 03:42 PM

Does this help?

Please Login or Register  to view this content.

Will place the last 6 characters from A1 into B1.

**walruseggman** · 11-24-2014, 03:43 PM

Yes.

Please Login or Register  to view this content.

**Rasputin24** · 11-24-2014, 03:45 PM

Originally Posted by walruseggman

Yes.

Please Login or Register  to view this content.

Works perfect, thank you so much for your quick response!

**PCI** · 11-24-2014, 03:48 PM

Have a look on the function "Right"
in A1 = Right(E1,6)
where the characters to extract are at the end of cell E1

**MarvinP** · 11-24-2014, 03:50 PM

Hi Ras,

Try this formula

=IF(LEN(E2)>5,MID(E2,LEN(E2)-5,LEN(E2)),E2)

Then copy and Paste the new column over the old one, using "Values Only".
No VBA needed, and it will work a lot faster.