| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to columns - right-aligned text
I have a column which contains a product description (in text) and
catalogue/EAN number (numeric). The description varies in terms of number of characters whereas the catalgoe number doesn't. I want to right justify/align the column and then text-to columns so I can pick the number away from the original column - a kind of reverse concatenate. Any suggestions out there? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to columns - one way street? | Excel Discussion (Misc queries) | |||
| How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
| comparing columns of text (cross-searching) | Excel Discussion (Misc queries) | |||
| Text to columns | Excel Discussion (Misc queries) | |||
| Text to Columns in excel for delimited files - allow trimming opt. | New Users to Excel | |||
Threaded Mode
