Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

Pull data out of cell

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
cansevin
Asked:
cansevin
1 Solution
 
mcsweenSr. Network AdministratorCommented:
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
 
Shanan212Commented:
=MID(B2,FIND("(",B2),13)

Open in new window


if the phone number is

(xxx) xxx-xxxx then

=MID(B2,FIND("(",B2),14)
0
 
cansevinAuthor Commented:
Thanks!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now