Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formula 1
- Thread starter CCPKGUY
- Start date
Assuming that the old number is in A1, formula in another cell:
=SUBSTITUTE(A1," ","-")
If you just need to replace existing value by a new one, use excel's find & replace functionality (search for " ", replace by "-", without quotes) for a selected range.
combo
=SUBSTITUTE(A1," ","-")
If you just need to replace existing value by a new one, use excel's find & replace functionality (search for " ", replace by "-", without quotes) for a selected range.
combo
- Thread starter
- #3
F1 is your friend!
You have those two values in two columns, say A1 and B1, right?
=>in C1:
=CONCATENATE(A1,"-",B1)
“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.
You have those two values in two columns, say A1 and B1, right?
=>in C1:
=CONCATENATE(A1,"-",B1)
“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.
-
1
- #5
- Thread starter
- #6
- Status
Similar threads
- Locked
- Question