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!
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!
A sample as per the yellow ribbon would make things simpler but
=SUBSTITUTE(B1," ","-")&SUBSTITUTE(C1," ","-")
may be a start
Ok that works (I just added & “-“), ill wait for another reply just to have two options in my arsenal
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks