Excel repeat formula ..???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am wanting to find a formula to repeat text that is in 3 different cells
and am wanting to have it seperate them by a (-) dash

what i am doing is creating a sku

example of text in excel:

a2-0140441875, b2-ROW1, c2-001

and in any given cell i would like for it to take the text from cell a2, b2,
and c2
and have it appear like this

0140441875-ROW1-001

i can get it to repeat only one cell but i would like to grab my three cell
of info and have them be placed in another cell together seperated by
somethings preferably a dash (-s)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas across columns 2
countifs Function not giving desired result with date criteria 2
Sum automatically every cell in multiple rows 1
compare cells, copy, loop 2
use cell text in lookup function 3
search function using wildcard 3
Repeat formula for all cells in whole column 1
If formula 5

Back
Top