Segregation of Numbers

A

akber.431

New Member
Joined
Jun 1, 2011
Messages
42
Can any one help me in Excel

in one worksheet i have in cell (A)1001000001 i want it to be segragate in the numbers


cell(B) 1001
cell(c)000001

plz help me out in this problem

Thanks
Regards
Akber
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
Welcome to the board.

For Column B use:
Code: 
=LEFT(A1,4)
For Column C use:
Code: 
=RIGHT(A1,LEN(A1)-4)
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
VBA How to auto populate number randomly with criteria that each person must be picked once
2
Replies
12
Views
480
AmirFirdaus9509
A
C
  • Solved
Formula using match, indirect, and vlookup returning 0
Replies
1
Views
294
Ccruz444
C
D
  • Solved
VBA If statement to continue
2
Replies
17
Views
559
dinunan
D
K
  • Question Question
Convert Index numbering to level number
Replies
8
Views
436
Bosquedeguate
Bosquedeguate
M
  • Solved
Copy of specific data from one sheet to another
Replies
4
Views
217
mahmoudguda29
M

Forum statistics

Threads
1,223,268
Messages
6,171,100
Members
452,379
Latest member
IainTru

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top