paste csv text string

[John Keith]

Is there a way to have a string from the cut/paste buffer which is in
the form of "ABC, DEF, HIJ" be entered into adjacent cells rather than
all the text into one cell? In this case A1 would have "ABC", B1 would
have "DEF" and so on. I know I can put the string into a file and name
it xxx.csv and open it to ccomplish the task but I'm trying to save
some steps.

TIA
John Keith
(e-mail address removed)

 

[Gord Dibben]

John

ABC, DEF, HIJ.............what happened to G<g>

I would copy and paste then use the Data>Text to Columns Wizard and set a
delimiter as comma.

Will break it up quite nicely.

If you first select a column and do the above steps, Excel will use that default
next time you paste into a cell in that column and save the steps.

If a repetitive task........use the macro recorder.


Gord Dibben MS Excel MVP

 

[John Keith]

ABC, DEF, HIJ.............what happened to G<g>

That is an indicator of how tired I am right now.

I would copy and paste then use the Data>Text to Columns Wizard and set a
delimiter as comma.

Will break it up quite nicely.

That is exactly what I wa looking for. Thanks You saved me some time,
maybe I can get to bed early tonight!


John Keith
(e-mail address removed)