[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Pull info out of excel field

Posted on 2013-11-18
2
Medium Priority
?
256 Views
Last Modified: 2013-11-18
I have a column of data in Column B. Every entry has a time at the end of the text, right after the "at ". Such as

New voicemail from Unknown Caller at 12:43 PM
New voicemail from (949) 673-5942 at 12:08 PM
New voicemail from (510) 207-4795 at 11:15 AM

In column C, I want just that time stamp and nothing else. Any idea how to make this happen?

Thanks!
Chris
0
Comment
Question by:cansevin
2 Comments
 
LVL 7

Accepted Solution

by:
Beneford earned 2000 total points
ID: 39657576
Set the formula of column B to: =MID(A1,FIND(" at ",A1)+4,LEN(A1))
If you want the value as a Time (as opposed to text), use
=VALUE(MID(A1,FIND(" at ",A1)+4,LEN(A1)))

(Then change the cell format to 'Time' so it shows as a time value).
0
 

Author Closing Comment

by:cansevin
ID: 39657598
Thanks, works great.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

607 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