LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Banned
 
Posts: 4
Default Formula for numerical data needed!

Im building a unique data base to uploaded into quickbooks of over 5000 products that all have a unique 12-digit UPC code as shown below. The way I want to set up my file involves me using this code but only 5-digits of it that still remain unique throught the 5000 products. I'd like to simply do what I do when I copy/paste formulas to a specific row to get the outcome. For example, below

610764180018
would be in my system '18001'
610764111319
would be in my system '11131'

I need to find a way to chisle off the first six and last one digits to make a 6-digit code.

I know the forumula must be simple and out there, but I've looked around and have spent a few hours with this. Any ideas out there? Very much thanks!
Sean
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need my formula to analyse numerical and text data Nightrunning Excel Discussion (Misc queries) 4 May 22nd 09 06:45 PM
Formula needed: argument changes as more data is added BK Excel Worksheet Functions 9 March 12th 09 02:24 AM
Devise a formula to add non numerical data Karin-LRC Excel Discussion (Misc queries) 2 November 11th 08 02:06 AM
Numerical data formula Thyag Excel Worksheet Functions 5 August 14th 07 01:16 AM
Alpha & Numerical Help Needed talltom Excel Worksheet Functions 6 January 9th 07 07:20 PM


All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"