Posted to microsoft.public.excel.newusers

external usenet poster

Posts: 4

Stripping digits from a column

Hi,
I've a column containing alphanumeric text as 200731705A832565410B12345678.
Out of this text, I need only the 9 right most digits.
How do I go by?
TIA,
Mark

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 to customize number to 10 digits including 2 digits after deci	Carina	Excel Worksheet Functions	3	September 20th 07 02:50 AM
Remove first few digits from all cells in the column	Magwine	Excel Worksheet Functions	7	August 2nd 07 10:39 PM
Delete first two digits in column	rjtees	Excel Worksheet Functions	4	November 17th 05 09:22 PM
How to set a column to accept only a specified number of digits	ashvik	Excel Worksheet Functions	1	September 26th 05 11:11 AM
Stripping time in Pivot Table Column Header	T1 Red Alarm	Excel Worksheet Functions	3	May 18th 05 12:09 AM

All times are GMT +1. The time now is 08:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us