Is there a function for this....
DUH!!!!! Thanks...it worked!
"Toppers" wrote:
Use EDIT ==Find== Replace
Highlight column
Edit /find /replace
Find what: - (your dash)
Hit "Replace all"
Backup data first!
"Tiffani" wrote:
This could just be laziness, but with I dont want to do it for 3000 cells.
I work for a company where we can upload prices into our system that we use
with an excel spreadsheet. But the company who sends us the price list, has
dashes and spaces in their item numbers and our system doesnt us the dases
and spaces.
So, is there a way to have excel go through and take them out. Or will I
just need to suck it up and go through each one and take out the dashes and
such.
For example, their item # looks like this: ALA-6-150
our item # would be: ALA6150
Please help if you can.
Thanks!!!
|