excel vba - VBA macro for text-to-columns -


i'm trying write code following:

  1. using text-to-columns,the data should divided in different columns. data in cells a1-a8 this:

enter image description here

this data should appear in different columns.

like this?

sub macro() selection.texttocolumns destination:=range("a1"), datatype:=xldelimited, _     textqualifier:=xldoublequote, consecutivedelimiter:=false, tab:=false, _     semicolon:=false, comma:=false, space:=false, other:=true, otherchar _     :=":", fieldinfo:=array(array(1, 1), array(2, 1)),  end sub 

Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -