Solved

how to extract value from cell in excel

Posted on 2014-09-24
1
168 Views
Last Modified: 2014-09-24
Hi Experts,

How can I get 'John_Doe' from this string in excel: /blah/blah.blah/blah_blah/John_Doe?
0
Comment
Question by:daintysally
1 Comment
 
LVL 17

Accepted Solution

by:
Emmanuel Adebayo earned 500 total points
ID: 40342168
Hi,

You can use the LEN function in Excel to manipulating text in Excel

Check the link below
http://www.giveandtake638.com/it-system-administration/retrieve-data-selectively-cells

regards
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

This tutorial is about how to put some of your C++ program's functionality into a standard DLL, and how to make working with the EXE and the DLL simple and seamless.   We'll be using Microsoft Visual Studio 2008 and we will cut out the noise; that i…
After several hours of googling I could not gather any information on this topic. There are several ways of controlling the USB port connected to any storage device. The best example of that is by changing the registry value of "HKEY_LOCAL_MACHINE\S…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

775 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