Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function for this....
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |