paste csv text string

  • Thread starter Thread starter John Keith
  • Start date Start date
J

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)
 
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
 
ABC, DEF, HIJ.............what happened to G<g>
Click to expand...

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.
Click to expand...

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)
 
Back
Top