Excel 2007 : Truncation and search

Hello everyone - I am new here and new to Excel 2007.
Where I work we need to do an inventory of all Laptops and desktops. To save time I would like to create an excel macro that will trunc off un-needed info and also do a search to locate a found asset. Below is an example:

Raw data = 1s64585kul3d7275
data removed = 1s64585ku
whats left = l3d7275

I would like it to search my document for = l3d7275 so that I may verify the asset has been found ( I can bold it, etc.)

Is this possible to do or... ?
Any help would be greatly appreciated.

Thank you!

Hi,

Yes ... it can be done ...
What determines the portion to be truncated ...? is it the length ...?

Yes- I would like it to retain only the last 7 characters (Alpha Numeric).

AH! I see. And if I want to enter all raw data in A and have B retain the last 7 digits would it be along the lines of:

=RIGHT(A#,7)

Hmm ok -

What if I wanted to use column "A" to input all raw date and have it output only the last 7 characters in "B" colume? (See Below). Is your formula =RIGHT(A,7) ??

\1

Got it :-D~!

Can you have excel do a search after it leaves the last 7 characters to see if that entry is already on the spreadsheet? Example - when I use the barcode scanner it will input the raw data then leave only the last 7 characters. Can the last 7 characters be searched to see if they already exist on my sheet?

Hundreds :-)

I like making my life (and my co-workers lives) easier.

We couldn't for the life of us figure out the formula to merely remove all but the last 7 characters! Silly us :-P

Can you recommend any books to help smarten us up some?

EExxxcellent. Thank you!