| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Txt to columns
Well, you could record Text to Columns in a macro to shorten the
keystrokes. Or someone could probably write a long, choppy formula using MID and FIND and such functions to do this. I like using morefunc, which is a set of UDFs you can find on the net. So, assuming you import the numbers to column A, this formula in B1: =VALUE(WMID($A1,COLUMN()-1,1,"xx")) Assuming you want the numbers to be values, I wrapped this with VALUE. And the "xx" would have to be whatever is between the numbers from your import. Copy across and down to as many cells as necessary. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Linear Mode
