• Home
  • About Us
  • Submit your post
  • Drop us a line

Logo

Navigation
  • How-To Guides
    • Windows Server 2012
    • Windows Server 2008
    • Windows 10
    • Windows 8/8.1
    • Windows 7
    • MS Office
  • IIS Admin
  • Sys Admin
  • IT Certifications
  • Recommended Reading
  • Freebies
    • IT Ebooks
    • Online Training (IT)

How to retrieve Data Selectively from cells

MS Office

This post details the step by step to retrieve data selectively from cells

Assuming you have a spreadsheet below and you want to retrieve Normal1, Normal2 and Normal3 into another colum, say B.

retrieve_data_selectively

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

Select Colum B2 and enter =RIGHT(A2,LEN(A2)-10) where A2 is the colum that hold the data to be manipulated. the number 10 is the number of letter from J to the hypen infort of Normal, J being 1 and _ 10

retrieve_data_selectively1
If in the others in A3 and A4 are the same just copy the formular down.

retrieve_data_selectively3

Share Button
  • About
  • Latest Posts
Follow me

Emmanuel

IT Consultant/Architect at Alpha Consulting Holdings Limited
Emmanuel Adebayo is an IT Consultant/Architect with over 17 years experience, specialised in IT infrastructure administration and security; and in the management and troubleshooting of Microsoft products including (Windows XP/7/8, Windows Servers 2003/2008/2012, IIS6/7/8, ISA, and Active Directory).
Follow me

Latest posts by Emmanuel (see all)

  • How to Enable Failed Tracking Request in IIS7.0/8.5 - February 18, 2016
  • Switching from Local account to Microsoft account in Windows 10. - October 26, 2015
  • How to export a certificate with the private key - October 8, 2015

No related posts.

Tags: MS Excel

No Responses to “How to retrieve Data Selectively from cells”

Leave a Reply Cancel Reply

Your email address will not be published. Required fields are marked *

*
*


#1
#2
#3
Questions Answered
Articles Written
Overall Points
  • Popular
  • Recent
  • Comments
  • How to Enable Failed Tracking Request in IIS7.0/8.5

    February 18, 2016 - 0 Comment
  • Using Diskpart.exe to Perform Partition Alignment, and Assign Drive Letters

    May 26, 2014 - 0 Comment
  • Windows Server 2012 Editions overview

    July 18, 2014 - 0 Comment
  • How to resolve “the Local Security Authority cannot be contacted” error

    July 22, 2014 - 0 Comment
  • How to Protect USB drive with USB Safeguard

    July 29, 2014 - 0 Comment
  • How to Enable Failed Tracking Request in IIS7.0/8.5

    February 18, 2016 - 0 Comment
  • Switching from Local account to Microsoft account in Windows 10.

    October 26, 2015 - 0 Comment
  • How to export a certificate with the private key

    October 8, 2015 - 0 Comment
  • How to use the IISADMPWD on IIS7.0

    October 6, 2015 - 0 Comment
  • How To Check If Your Computer Is Ready For Windows 10

    July 31, 2015 - 0 Comment

Connect us on Social Media

RSSSubscribe

Upcoming Events

  • Introduction to Information Technology
    • 9 Dec 19
  • Introduction to Information Technology
    • 16 Dec 19
  • Introduction to Information Technology
    • 23 Dec 19
  • Introduction to Information Technology
    • 30 Dec 19
  • Introduction to Information Technology
    • 6 Jan 20

Latest Tweets

Tweets by @giveandtake638

Archives

Quick Links

About Giveandtake638
Drop us a line
Submit your post
Recommended Reading
Online Training IT
IT Ebooks

Categories

  • IIS Admin (5)
  • MS Office (2)
  • Others (1)
  • Sys Admin (10)
  • Uncategorized (4)
  • Windows 10 (3)
  • Windows 8/8.1 (1)
  • Windows Server 2012 (2)
  • Home
  • Contact Us
@2016 Giveandtake638.com All Rights Reserved