Solved

Pull data out of cell

Posted on 2012-12-27
3
218 Views
Last Modified: 2012-12-27
I have a column of cells in Column B that text similar to:

"New voicemail from (xxx) xxx-xxx at 2:42 PM"

Obviously the "x's" are actual number of a phone number. In column C, I want to have just the phone number from that cell. Any ideas?
0
Comment
Question by:cansevin
3 Comments
 
LVL 21

Expert Comment

by:mcsween
Comment Utility
Select your column with this data, Click the Data Tab, Text To Columns, Select Fixed Width, remove the breaks you don't want on the next screen, and add ones leading and trailing the phone number.
0
 
LVL 13

Accepted Solution

by:
Shanan212 earned 500 total points
Comment Utility
=MID(B2,FIND("(",B2),13)

Open in new window


if the phone number is

(xxx) xxx-xxxx then

=MID(B2,FIND("(",B2),14)
0
 

Author Closing Comment

by:cansevin
Comment Utility
Thanks!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
excel file 5 42
Index & Match Help 2 22
how to open excel file size more than 2 GB 3 41
Scrape Data from a list of hyperlinks 3 26
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now