+ Reply to Thread
Results 1 to 4 of 4

Pull value that ends with "GB" and "Minutes" into a new column

  1. #1
    Registered User
    Join Date
    06-22-2022
    Location
    England
    MS-Off Ver
    2016
    Posts
    3

    Pull value that ends with "GB" and "Minutes" into a new column

    Hi Guys,

    Need your help with Pulling all the value that ends with "GB" from a column into new column.
    Data in the column is alphanumeric for example- 1.2656524GB

    Sorry, I am new to excel so any help is greatly appreciated
    Last edited by AliGW; 06-22-2022 at 06:18 AM. Reason: Irrelevant section of title removed.

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,775

    Re: [HELP] Pull value that ends with "GB" and "Minutes" into a new column

    Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

  3. #3
    Registered User
    Join Date
    06-22-2022
    Location
    England
    MS-Off Ver
    2016
    Posts
    3

    Re: Pull value that ends with "GB" and "Minutes" into a new column

    Updated attachment
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-22-2022
    Location
    England
    MS-Off Ver
    2016
    Posts
    3

    Re: [HELP] Pull value that ends with "GB" and "Minutes" into a new column

    Hi Caracalla, i was hoping to pull the values from "call duration" column according to the "call type" into the column "over by-data" and "over by- mins" however the limit is 5gb and 300 minutes so anything over should go "over by " column and it should show how much its over by

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-05-2021, 09:24 AM
  2. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  3. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  4. How to use InStr function to search for a text that starts with "CTF" and ends with "."?
    By yoursamrit2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2014, 06:52 PM
  5. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  6. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  7. Replies: 0
    Last Post: 07-09-2009, 04:07 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1