Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pulling out specific characters
My entire database from QuickBooks combines the categories with the products,
which is fine. I can get the text to look almost exactly how it needs to be to be uploaded to our e-commerce site; the only thing we need to do is seperate the characters after the last /// in each cell for the entire column (which is the actual product ID). Here are a few samples: SENSORS///Pressure & Vacuum///MPS-1 Basic///MPS-P1G-PC SENSORS///Pressure & Vacuum///MPS-V2C-NC The characters at the end are always the product id's which we need seperated, and have the last "///" removed. So it will look like this: SENSORS///Pressure & Vacuum///MPS-1 Basic (then in the next column) MPS-P1G-PC SENSORS///Pressure & Vacuum (then in the next column) MPS-V2C-NC If I could just extract the the character after the last /// that would be fine, I could then Text To Column the categories and put them back without the last /// on the end. But if I could cut that out as well that would save me a step. With over 15K products this will save a massive amount of time. Thank you very much for any help. -- Louis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run a Macro on Startup for Specific Spreadsheet | Excel Worksheet Functions | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
pulling characters out of a string | Excel Worksheet Functions |