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 Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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
540
AmirFirdaus9509
A
C
  • Solved
Formula using match, indirect, and vlookup returning 0
Replies
1
Views
327
Ccruz444
C
D
  • Solved
VBA If statement to continue
2
Replies
17
Views
651
dinunan
D
K
  • Question Question
Convert Index numbering to level number
Replies
8
Views
441
Bosquedeguate
Bosquedeguate
M
  • Solved
Copy of specific data from one sheet to another
Replies
4
Views
230
mahmoudguda29
M

Forum statistics

Threads
1,224,503
Messages
6,179,134
Members
452,890
Latest member
Nikhil Ramesh

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