Split cell content based on a column break fixed width

Originally Posted by Sawred

I need help with Text to Columns, I have the actual column numbers, and would like to input them by number not clicking on that stupid screen thing, how can I do that? Here's a link to what I am describing.

I know where I want to seperate, and don't want to use that clicking thing, please help thanks

http://office.microsoft.com/en-us/ex...498511033.aspx

I think phrases such as "that stupid screen thing" could be avoided in a forum.

If you want to split specific characters of data into known columns by formula then perhaps the Mid() function will better suit your purpose.

If you want to specify the data by character numbers as you seem to describe, then a little learning of VB code will permit you to use the FieldInfo:=Array(Array(0, 1), Array(2, 1), Array(6, 1) etc portion of the Selection.TextToColumns Destination:= command.

Otherwise, the screen presented in TextToColumns gives a changeable setup option together with a display of the intended result, and can be useful where data is varied. Entering dividers at the correct character number position should not prove too difficult.

---