+ Reply to Thread
Results 1 to 3 of 3

Combining Concetenate & Substitude Functions

  1. #1
    Registered User
    Join Date
    04-22-2020
    Location
    Israel
    MS-Off Ver
    18.2992.1101.0
    Posts
    6

    Combining Concetenate & Substitude Functions

    Hi!

    I got a list of products (B) and manufacturers (C) which i woud like to combine into column A and replace the spaces with hyphens.

    Any ideas of how to nest these functions?

    Thanks!

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Combining Concetenate & Substitude Functions

    A sample as per the yellow ribbon would make things simpler but
    =SUBSTITUTE(B1," ","-")&SUBSTITUTE(C1," ","-")

    may be a start

  3. #3
    Registered User
    Join Date
    04-22-2020
    Location
    Israel
    MS-Off Ver
    18.2992.1101.0
    Posts
    6

    Re: Combining Concetenate & Substitude Functions

    Ok that works (I just added & “-“), ill wait for another reply just to have two options in my arsenal

+ 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. Introduction and question about substitude to convert kml to geojson
    By Kievet in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-26-2020, 02:31 PM
  2. Combining Two Functions
    By PKW57 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-30-2015, 04:03 PM
  3. Concetenate multiple matches into a single cell
    By penfolda in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-05-2013, 06:57 AM
  4. Complex Concetenate of cells using vba
    By lavinius in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2013, 03:39 PM
  5. Combining multiple functions>lookup/sum functions
    By mush106 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2013, 07:47 AM
  6. Combining two IF Functions
    By sprejr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2007, 01:34 PM
  7. Combining IF OR and AND functions
    By andyp161 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-20-2006, 01:10 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