Finding Numbers

G'day all,

Could someone point me in the right direction please.
The formula I have been using to locate 3 numbers from a column is: =IF(ISERROR(MID($A4,COLUMN()-1,1)*1),MID($A4,COLUMN()-1,1),MID($A4,COLUMN()-1,1)*1)

Previously I only needed to enter 3 numbers into column A and the formula would seperate those numbers into B1,C1 & D1, now I need to enter on average 12 numbers ie:123456789123, the formula I need now is something that will only pick up the last 3 numbers on the right ie: 1,2,3.
As you may be able to tell from the formula above it will only pick up the numbers on the left, where am I going wrong lol.

Any help in relation to this problem is much appreciated & I thank you in advance!

Regards,
NB

I have tried your formula, it works well
I copy and paste the formula from b1 until m1, then there are the 12 separated numbers.
I think it's correct
and I have a simpler formula for you.

=MID($A$4,COLUMN()-1,1)

Thanks for reply SG,

Still not working or not working how I need it to,
try this:
B1 to J1 & insert the formula =MID($A$1,COLUMN()-1,1)
B2 to J2 & insert the formula =MID($A$2,COLUMN()-1,1)

Now in A1 type 123156665
Now in A2 type 5312

The result will show the numbers from B1-J1 (thats fine)
on the 2nd line it will only show the numbers from B2-E2 when in actual fact I would need them on the other side of the page in cells G2-J2

Its the last 3 digits I need on the right hand side

Does this make sense?

Regards,
NB

HI There,

Try this =MID($A1,COLUMN()-1,1)
You need to emone "$" sign to row.

Thanks Sandeep,
That doesnt work either, no matter how many numbers I type in, I need the numbers on the right to show first.

Does this help?

Thanks,
NB

Start at J2 and copy this formula: =MID($A$2;11-COLUMN();1)
Copy left till B2
For readability: =MID($A$2;COLUMN($K$2)-COLUMN();1)
Copy left till B2

Thanks for reply rwgrietveld
Tried it, nothing seemed to happen, all it did was insert the same formula =MID($A$2;COLUMN($K$2)-COLUMN();1) from J2:B2

Perhaps I am doing wrong

make sure B2:J2 have this formula (all the same)=MID($A2;COLUMN($K2)-COLUMN();1) and A2 is the number e.g. 5532 or 123456789012

Thanks for reply RW,
I tried inserting that formula and all it does is shown in the example, no matter what I do whenever I insert the formula it seems to be non interactive.

Regards,
NB

G'day All,

What is happening is international help. Which is great !! but......

In some countries the comma is used and the other countries use the semi comma.

In Australia we use the comma to separate the formula functions.

Try this

Please Login or Register  to view this content.

Not this

Please Login or Register  to view this content.

HTH

Originally Posted by martindwilson

semi-comma old chap? semi-colon i think

LMAO I think your right

Those fingers not listening to the brain again. lol

G'day there RatCat,

Thanks for showing the way mate, was banging my head against the wall wondering why it wouldn't work, Big thanks to rwgrietveld, it more or less does the job mate, don't want to take up any more time, much appreciated friend.

Good to see more Aussie's on this site RatCat, just west of Wagga here.

Regards,
NB

G'day everybody,

Just thinking the other day, if your still stuck try the following

B1 =MID(RIGHT(A1,3),1,1)

C1 =MID(RIGHT(A1,3),2,1)

D1 =MID(RIGHT(A1,3),3,1)

HTH