Split the Data in a Column by Using the Left and Right Function.

Posted on December 11, 2007
Filed Under Excel Tips & Tricks, Reader Questions

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

I’ve received an e-mail from Anne asking if I could help out with a problem that she has at work. She gets a list on her desk quite frequently with on column full of data with 10 numbers (9+1). She needs to strip this data so that she only has the last 7 digits left.

@Anne, I hope I have this right. Just to be sure I’m also showing the way to keep the left 3 digits. It works practically the same. If I didn’t understand your mail right please let me know, okay?

For this Excel Tip or Trick were using the LEFT and RIGHT function to separate a row full of data from a determent amount of digits.

And this is how you do this.

Enter in an Excel Worksheet a certain quantity of 10 character values. (it doesn’t matter if you are using numbers or letters)
Select the cells B1:B8
Enter =LEFT(A1;3)
And press CTRL+ENTER

Excel Tip Trick

Select the cells C1:C8
Enter =RIGHT(A1;7)
And press CTRL+ENTER

Excel Tip Trick

I hope you all enjoyed this very handy Excel Tip and Trick.

Do you want to see more? This is related...

Did you ever thought about publishing your own eBook or PDF report?

Invite your friends to the World of Office.

Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!

If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.