Auto Shorten a Data String
 

I have 2 worksheets that I wish to perform Vlookup references from...
the lookup data comprises of a 6 digit numeric value.
My problem is that on one of the sheets the data string has been augmented
by a 7th character and I am looking for a way to delete the last character in
this string and allow me to do the lookup between 6 digit values ??

ie. Worksheet 1 ... data 123456 .... Worksheet2 1234567 ...
I wish to drop the 7 in this case

Is there an automated way to do this as I have 10,000 entries ??

Many Thanks

Alan

Please Ignore ... Found the LEFT Function and it does the trick

Many thanks anyways

Alan

"Alan" wrote:

I have 2 worksheets that I wish to perform Vlookup references from...
the lookup data comprises of a 6 digit numeric value.
My problem is that on one of the sheets the data string has been augmented
by a 7th character and I am looking for a way to delete the last character in
this string and allow me to do the lookup between 6 digit values ??

ie. Worksheet 1 ... data 123456 .... Worksheet2 1234567 ...
I wish to drop the 7 in this case

Is there an automated way to do this as I have 10,000 entries ??

Many Thanks

Alan