MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Extract a portion of data within a cell...


Posted by David Micka on May 03, 2001 10:00 AM

Does anyone know a way to extract only a portion of data within a cell and place it in a different cell. For example, each cell in column A always contains a six digit number - I want the adjacent cell in column B to automatically display the last four digits of the six digit number in A. Any ideas on a formula, etc. that might accomplish this?


Posted by Aladin Akyurek on May 03, 2001 10:05 AM


=RIGHT(A1,2)

or

=RIGHT(A1,2)+0 if you want a number result.

Aladin

Posted by Aladin Akyurek on May 03, 2001 10:07 AM

Make 2-->4 (NT)

Posted by Mark W. on May 03, 2001 11:35 AM

We're both stuggling today...

I put in an 18-hour day yesterday. Didn't get
home 'til 1:30 this morning. Should be on
vacation today, but still tying up loose ends.

Posted by Mark W. on May 03, 2001 11:36 AM

Can't even type "struggling" : )

home 'til 1:30 this morning. Should be on vacation today, but still tying up loose ends. :

Posted by Aladin Akyurek on May 03, 2001 12:04 PM

Re: We're both stuggling today...

Yeah. Those long hours. But no vacation for me. Not yet. How long will it take that vacation? Coming to Europe, by any chance?

I put in an 18-hour day yesterday. Didn't get home 'til 1:30 this morning. Should be on vacation today, but still tying up loose ends.

Posted by David Micka on May 03, 2001 12:07 PM

Re: Make 2-->4 (NT)

Thank you SO much, Aladin, that's exactly what I needed!

Posted by Mark W. on May 03, 2001 12:19 PM

Re: We're both stuggling today...

No, I'm just consuming a couple of days -- use it
or lose it! Late in May I'm taking slightly more
than 1 week off to visit my brother in Louisville,
Kentucky. The home of the Kentucky Derby. Yeah. Those long hours. But no vacation for me. Not yet. How long will it take that vacation? Coming to Europe, by any chance? : I put in an 18-hour day yesterday. Didn't get : home 'til 1:30 this morning. Should be on : vacation today, but still tying up loose ends.