If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|