Posted to microsoft.public.excel.misc

[email protected] dstdst123@excite.com is offline

external usenet poster

Posts: 5

How to auto delete the first X digits in a cell number ?

Hi there,

I have the following in Cell A1 to A3.

ABC50293.01
ABC10006
ABC1000003

I want to automatically delete the first 4 digits in each cell, so
that it will become:

0293.01
0006
000003

How can i do that?

Thanks a lot.

cheers:)

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 delete the 4 rightmost digits from a cell	charlene	Excel Worksheet Functions	4	June 29th 06 03:11 PM
Delete 4 to 5 digits from left in a cell	Bob Phillips	Excel Discussion (Misc queries)	2	April 27th 06 08:19 PM
Delete 4 to 5 digits from left in a cell	Peo Sjoblom	Excel Discussion (Misc queries)	3	April 27th 06 08:10 PM
Delete 4 to 5 digits from left in a cell	Toppers	Excel Discussion (Misc queries)	0	April 27th 06 07:33 PM
calculate using last four digits of number in cell	Andy Falkner	Excel Worksheet Functions	3	February 10th 06 05:30 PM

All times are GMT +1. The time now is 06:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us