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!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function for this....
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!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function for this....
Tiffani
Assuming your data is in A1 and all of the items have the same makeup (ie dashes are the 4th and 6th character and the same number of characters) this will work =LEFT(A1,3)&MID(A1,5,1)&RIGHT(A1,3) Dave "Tiffani" wrote in message ... 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!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
Reply |
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 |