+ Reply to Thread
Results 1 to 2 of 2

Split text in a column using an entire word and not just a single character

  1. #1
    Registered User
    Join Date
    09-20-2019
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    9

    Split text in a column using an entire word and not just a single character

    I have an excel doc with multiple addresses, and some of them are in the form:

    312 Main St. Suite 6
    1234 Victoria St PO Box 231
    12 Amherst Rd Unit 3

    What I want to do is if the addresses contain either Suite, PO Box, or Unit, I want to remove it from the current column and put it into the column next to it. How do I go about doing this in Excel?

    I also posted the question in another forum (Excel General) because I wasn't sure where to post it.
    Last edited by hisuh1; 09-26-2019 at 01:33 PM.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Split text in a column using an entire word and not just a single character

    Assumes that the addresses are in Column B starting at the 2nd row.
    There must be better macros around but you could start with something like this.
    Please Login or Register  to view this content.
    Please post the hyperlink to the other site. Do the same at the other site with a hyperlink to here.
    Last edited by jolivanes; 09-26-2019 at 02:38 PM. Reason: Add "Trim"

+ 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] Delete Entire Row where there is text (word) in the Column
    By Patish in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2016, 09:55 AM
  2. [SOLVED] Split text by character
    By benbi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-25-2015, 02:38 PM
  3. Split a single word document into multiple word documents
    By CaptainCool in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2014, 03:31 AM
  4. Having problem with text to column split on a particular word
    By alicia ch in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-01-2012, 12:29 PM
  5. Replies: 10
    Last Post: 10-24-2012, 04:02 AM
  6. Excel 2007 : How to split to column at character
    By PBMClubber in forum Excel General
    Replies: 6
    Last Post: 11-22-2010, 07:50 AM
  7. vlookup,replace word with single character
    By vascott01 in forum Excel General
    Replies: 6
    Last Post: 03-05-2010, 09:04 AM

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