Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default delete numbers in each cell in same column

You can use TTC and not have to use formulas or helper columns.

Select the data in the column, then, from the Menu Bar,
<Data <Text To Columns <Fixed Width <Next,

In the second step of the Wizard, click in the "Data Preview" window to
place the break line between the 2nd and 3rd digits.

Then <Next

In the 3rd step of the Wizard, you'll see that the first 2 numbers are
selected (colored black), and in their own column.

NOW, click on "Do Not Import - Skip", which will skip that selected column
containing the first 2 numbers.

Finally click <Finish, and you're done.

Your numbers, minus the first two digits, are all that remain in the Column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Anna Huber" <Anna Huber @discussions.microsoft.com wrote in message
...
Is there an easy way to just delete the first two numbers in each cell all
the way down the column? i.e. 123456789 to 3456789? Would I have to
create
a helper column; put in a formula for the removal of the first two numbers
then cut and paste on the column I want to adjust? If so, can you tell me
specifically how to do this and why I am this specific formula to achieve
this action....... Thank you!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Copy column header to next column, delete & delete every nth colum genehunter New Users to Excel 1 June 2nd 09 03:57 PM
To delete paired numbers or pickup last cell for each item Salman Excel Discussion (Misc queries) 0 March 31st 09 04:21 PM
how to delete repeated numbers in a column, make it apears once sam Excel Discussion (Misc queries) 1 April 3rd 08 06:33 PM
HOW DO I DELETE NUMBERS IN A COLUMN out of each cell Completely Confused New Users to Excel 2 September 13th 06 09:23 PM
How do I delete numbers in a cell Therese Excel Discussion (Misc queries) 2 December 1st 05 10:22 AM


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"