+ Reply to Thread
Results 1 to 5 of 5

Remove preceding data from cells

  1. #1
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Remove preceding data from cells

    Hi guys,

    I've attached a sample file from which i want to remove the preceding numbers, spaces and hyphens from the values in col F (highlighted in yellow).

    Can't find any way at all of doing it in Excel .

    Thanks guys!

    Z
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Remove preceding data from cells

    This formula should do:

    =MID(TRIM(F2), FIND(" ", TRIM(F2), FIND(" ", TRIM(F2))+1)+1,256)

  3. #3
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Re: Remove preceding data from cells

    Hi,

    I wondered if you could help me evolve the VB script in the attached file so that it ALSO removes "_" (underscores), "-" (hyphens) and spaces from cell values?

    Script is:
    Please Login or Register  to view this content.
    Last edited by zudecke; 03-21-2018 at 08:17 AM.

  4. #4
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Remove preceding data from cells

    It is over my head, but maybe someone will be more helpful. But that is a function and it will do the same thing as my formula(except that is not working yet).

  5. #5
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Re: Remove preceding data from cells

    Worked it out through a couple trial and errors:

    Please Login or Register  to view this content.
    If anyone's interested!

    Thanks all!

+ 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. [SOLVED] Remove preceding spaces in column?
    By nobodyukno in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2018, 02:35 PM
  2. highlight cells containing specific textg and preceding cells
    By Veroshima in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2017, 07:44 AM
  3. [SOLVED] Populating cells with preceding value
    By coach.32 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-15-2016, 11:10 PM
  4. Replies: 3
    Last Post: 11-11-2014, 03:09 PM
  5. Macro to remove characters preceding text descriptions
    By agent.orange in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2014, 06:32 AM
  6. [SOLVED] Formula to insert text in new column if preceding more than one of the preceding have val
    By aimeecrystalaid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-04-2013, 11:47 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