Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to find text string in a column and paste data in another nicolascap Excel Discussion (Misc queries) 8 March 14th 06 04:13 PM
consolidation of tables in excel with text and figures samenvoegen van sheets Excel Worksheet Functions 8 March 2nd 06 04:27 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 07:16 PM
how do I paste an excel column into one cell...tia sal Excel Discussion (Misc queries) 2 June 8th 05 03:27 PM
in excel can one repeat the text from a the last used column cell. Millard Excel Discussion (Misc queries) 1 March 18th 05 07:33 PM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"