+ Reply to Thread
Results 1 to 2 of 2

Substitute formula and column sorting question

Hybrid View

  1. #1
    Registered User
    Join Date
    11-11-2021
    Location
    Brisbane
    MS-Off Ver
    365
    Posts
    6

    Substitute formula and column sorting question

    Hi Team

    2 questions.


    1. I would like to substitute all occurrences of "All" with multiple words in that cell.

    2. I want to organise each state separately in its own column


    Examples of what I would love to be able to achieve attached.
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Substitute formula and column sorting question

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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. Question about a "randbetween" substitute formula
    By HEV_tux in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2019, 04:05 PM
  2. SUBSTITUTE & LEN formula Question
    By Yizzll in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-16-2016, 10:02 AM
  3. Substitute for Sumfs formula with 1 row and 1 column for Criteria
    By Squint in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2015, 04:52 PM
  4. Two Column Sorting Question
    By mwgr5 in forum Excel General
    Replies: 1
    Last Post: 06-11-2008, 08:16 PM
  5. 2 Column sorting question
    By cwg in forum Excel General
    Replies: 5
    Last Post: 01-20-2008, 08:30 AM
  6. Sorting in a Column & Totaling Question
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-19-2007, 08:06 AM
  7. Question regarding sorting a column of alphanumeric cells
    By dubvision357 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2007, 01:41 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