View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nginhong
 
Posts: n/a
Default How paste text from note pad to excel w/o using (Text to column) f

Hello,

How to copy and paste text from note pad to excel spreadsheet with automatic
text to column format without doing it manually.

Example from note pad:-

XXX XXXXX XXX XXXX XX XXX
qwwq qwrew ewqr ishdaf ewrl asdlkfj

Copy the above from note pad and paste to excel you will get all content in
a single cell then you have to use function "Text to column" to split it into
column.

I believe you can paste it to a excel spreadsheet without using function
"Text to column" to get the same result.

Kind regards,
Ngin Hong