Posted to microsoft.public.excel.programming

Ryis

external usenet poster

Posts: 2

removing digits from one column to another

hello I have a spreadsheet which I would like to create a formula which will
take a 13 digit number and remove the first 7 digits and leave me with the
last 5 digits of the number.

Thanks in advance,

Ryis

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
VBA write macro change column with 3 number digits to 4 digits the	James C[_2_]	Excel Discussion (Misc queries)	3	January 25th 10 03:12 PM
Removing Digits	Faraz A. Qureshi	Excel Discussion (Misc queries)	3	October 27th 09 02:09 PM
Removing unwanted digits	bill	Excel Discussion (Misc queries)	7	March 29th 07 02:10 PM
removing last 16 digits of the value of a cell	destrolennox	Excel Discussion (Misc queries)	4	July 19th 06 05:27 AM
Removing the last two digits of a cell	kestrel	Excel Worksheet Functions	3	May 17th 06 10:41 PM

All times are GMT +1. The time now is 07:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us