Posted to microsoft.public.excel.misc

MikeD1224

external usenet poster

Posts: 34

Split UPC Question

I have a column of data (column A) that contains UPC's. The length of the
UPC varies by product. I need a formula that will remove just the last digit
(check digiti) of the UPC for each entry.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Un-Split	Justme-in-Az	Excel Discussion (Misc queries)	4	December 30th 06 07:49 PM
Split box	ED	New Users to Excel	1	April 27th 06 09:43 PM
split bar	splittinheadache	Charts and Charting in Excel	1	April 13th 06 11:16 AM
Split a Value	Gabe	Excel Discussion (Misc queries)	4	December 20th 05 05:28 PM
Advanced Window Split & Freeze Question	Andrew	Excel Worksheet Functions	1	November 8th 04 01:50 AM

All times are GMT +1. The time now is 05:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us