Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Moving partial data from one column to another in Excel


(!)

AhrenBa's Avatar
AhrenBa AhrenBa is offline
Senior Member with 884 posts.
THREAD STARTER
 
Join Date: Jul 2005
Experience: Fairly Advanced
06-Apr-2008, 10:27 PM #1
Moving partial data from one column to another in Excel
Hey Guys,

I scanned in some phone numbers/names using OCR and need some help in Excel. Here is example I made real quick of what the list looks like:



Column A is fine. However, do you see Column B? It has the grade and then the phone number.

Here's what I mean in column B:
Grade [one space] phone number

So, it looks like this in the excel spreadsheet:
10 555-5555

Here's what I need to do. I need to find a way to automate the process of taking out the phone numbers from column B and moving them all to a new column (C). There are four grade numbers (9, 10, 11, and 12), so I can run the process on each grade to separate them.

How can I do this? Thanks.
CastleHeart's Avatar
CastleHeart CastleHeart is offline
Senior Member with 743 posts.
 
Join Date: May 2002
Location: Coast of North Carolina
07-Apr-2008, 01:51 PM #2
Put the formula:

=RIGHT(B2,8)

in C2. Adjust the 8 for the phone number if it includes area code. Then drag that formula down the number of rows you'd like.

- Castleheart
jimr381's Avatar
Computer Specs
Member with 4,174 posts.
 
Join Date: Jul 2007
Location: Vienna, VA
Experience: Computer Illiterate
07-Apr-2008, 04:10 PM #3
You could also use "Data">>"Text to Columns" to split the columns in half using a space as the separator.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑