Excel Help-missing digits

Reply #6

Fibonacci — Mon, 01 Mar 2010 20:54:01 GMT

Got it! If anyone wants to use this here it is. It works for me (Excel 2007). Thanks to an online Excel forum helper.

Step 1

Add this fucntion to VB (alt F11) Insert Module

Function aconcat(a As Variant, Optional sep As String = ) As String

' Harlan Grove, Mar 2002

Dim y As Variant

If TypeOf a Is Range Then

For Each y In a.Cells

aconcat = aconcat y.Value sep

Next y

ElseIf IsArray(a) Then

For Each y In a

aconcat = aconcat y sep

Next y

Else

aconcat... [ More ]

Reply #5

markp1950 — Sun, 28 Feb 2010 01:35:52 GMT

I haven't used Excel, or haven't needed that function but in formatting in open office that have something called user-defined.

So look in the formatting help section under number formatting...

Best help that I can give you...

MarkP

Reply #4

Fibonacci — Sun, 28 Feb 2010 01:15:45 GMT

I just need 1 way. Grateful for any.

Reply #3

Raven62 — Sat, 27 Feb 2010 20:23:58 GMT

Their are many ways to do what you want: Just not in one Formula...

Reply #2

Fibonacci — Sat, 27 Feb 2010 20:13:16 GMT

It is. Basically the formula would check the original cell for digits 0 to 9 and return missing digits in the reporting cell.

I suspect it might involve the lookup function-- HLookup maybe. My Excel is rusty.

Reply #1

badboy00z — Fri, 26 Feb 2010 23:08:15 GMT

I don't think that is possible.

Excel Help-missing digits

Fibonacci — Fri, 26 Feb 2010 21:25:52 GMT

I'd like a formula to give the missing diits for any string of digits in an Excel cell.

E.g.

if cell A1 has 123 I want the formula to show 0456789

if cell A1 has 023467 the formula will show 1589

etc.