| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to columns with inconsistent data alignment
I have an imported column of cells with inconsistently aligned data that I
need to split between number & company. I can do the find & replace & then trim to get the co, but then I lose the vendor #. Is there a formula to accomplish this? 123-45ABC Corp 1111 XYZ Co 454455 DEFasdjkfalskdfjkajsdf 1some com name |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
text to columns with inconsistent data alignment
Try Delimited text to columns with 'Space' delimiter that should solve your
problem. If this post help resolve the issue, click 'Yes' to close the thread. "Sarah" wrote: I have an imported column of cells with inconsistently aligned data that I need to split between number & company. I can do the find & replace & then trim to get the co, but then I lose the vendor #. Is there a formula to accomplish this? 123-45ABC Corp 1111 XYZ Co 454455 DEFasdjkfalskdfjkajsdf 1some com name |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Cell alignment, how do I update the default vertical alignment | Setting up and Configuration of Excel | |||
| Text Alignment | Excel Discussion (Misc queries) | |||
| Data Alignment in columns | Excel Discussion (Misc queries) | |||
| Text alignment | Excel Discussion (Misc queries) | |||
| Graphing inconsistent dates and data | Charts and Charting in Excel | |||
Hybrid Mode
