Calculate number between two alphanumeric cells

Posted to microsoft.public.excel.misc

Jennifer Medina[_2_] Jennifer Medina[_2_] is offline

external usenet poster

Posts: 3

Calculate number between two alphanumeric cells

I need to calculate the difference between two alphanumeric cells. For example:

Column 1 Column 2
A16 A23 = 7

I have more complex alpha numeric strings such as:

Column 1 Column 2
1A732S 8C712E = ?

Any help would be appreciated

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
How can I seperate text and number from alphanumeric cell?	Jennifer Medina	Excel Worksheet Functions	3	November 15th 07 11:27 PM
how to remove number from alphanumeric cell	Igneshwara reddy[_2_]	Excel Worksheet Functions	3	April 12th 07 01:12 AM
Alphanumeric random number?	Michelle B	Excel Discussion (Misc queries)	6	November 7th 06 08:34 AM
how to calculate the number of non blank cells from any column?	Mahesh	Excel Worksheet Functions	2	August 8th 06 01:14 PM
how can I sort alphanumeric entries by number in excel	beasleyb	Excel Worksheet Functions	1	October 27th 05 10:17 PM

All times are GMT +1. The time now is 03:18 PM.

Menu

About Us