| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
| auto fill sequancial data | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Is there a way to get an auto page break as data changes in Excel. | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Threaded Mode
