Results 1 to 8 of 8

Need to remove random numbers and text from the left from each row

Threaded View

  1. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Need to remove random numbers and text from the left from each row

    with Power Query

    Currently
    [18238576,248375965]
    [11738495,249238575]
    [764548304,198378475,295767604,104956864]
    [183765663,1857569403]


    // Table1
    let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        ETAD = Table.TransformColumns(Source, {{"Currently", each Text.AfterDelimiter(_, ":"), type text}})
    in
        ETAD
    EDIT
    I noticed this is a MacOS so it may not work on this version 16.58
    Last edited by sandy666; 01-03-2023 at 06:46 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Remove before underscore Text from left or right in excel
    By druva in forum Excel General
    Replies: 9
    Last Post: 08-02-2019, 02:52 AM
  2. How to remove space on left of text?I can’t backspace it.
    By Excelforum*ser_mH7 in forum Excel General
    Replies: 11
    Last Post: 05-30-2018, 12:34 PM
  3. [SOLVED] Help! Remove numbers and all chars to left of the numbers.
    By trouble085 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-08-2012, 09:54 PM
  4. remove random spaces in a text string
    By mariusescu in forum Excel General
    Replies: 2
    Last Post: 07-10-2008, 03:32 PM
  5. Remove left text string
    By Luc in Oxford in forum Excel General
    Replies: 2
    Last Post: 08-23-2005, 06:05 AM
  6. [SOLVED] Create a formula to remove text to the left of specified char?
    By TheLazer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2005, 07:06 AM
  7. How do I remove all text to the left of the @ in an email address
    By David M in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-01-2005, 04:06 PM

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