Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to find text string in a column and paste data in another | Excel Discussion (Misc queries) | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
how do I paste an excel column into one cell...tia sal | Excel Discussion (Misc queries) | |||
in excel can one repeat the text from a the last used column cell. | Excel Discussion (Misc queries) |