help needed in ms excel ????????????

5 posts · originally from https://geek.digit.in/community/threads/help-needed-in-ms-excel.31881/

i am i need of u all excel guru(s).
i have some data in number format in a colum with 50,000 fileds
say that data contains 50,000 std codes and numbers all in one colum
like 0555222444
0556289523
05235236944
now i know that first four(4)digit are std codes
i want that first four digit from every no are cut(ed) and get pasted in new colum
i cannot to it by hand
as i hv 50,000 fields
what to do please help me

Suppose you have numbers in Column A, go to cell B1 and type the following forumla there
=LEFT(A1,4)
go to right, down position of cell B1, when you mouse cusros changes into thin black plus sign, double click the left mouse button

This is copy all the formula

this only copies first four digits from the cell
what i want is cut first four digit from the cell and paste it in another cell

Divide text across cells.
1. Select the range of cells that contains the text values. The range can be any number of rows tall, but no more than one column wide.
Note There must be one or more blank columns to the right of the selected column or the data to the right of the selected column will be overwritten.
2. On the Data menu, click Text to Columns.
3. Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into columns.
Note:
***On the Convert Text to Columns Wizard in the second step select fixed width
***I tried this successfully , please write back if u face any problems.

Looking forward to hear from u soon.
-keves-

thanks that worked