| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert text into columns
USER = ADMINISTRATOR
MAXPW = 1 MINPW = 1 NEWPASSWORDLIST = PASSWORD = ?ÅÎßÐÞÆÌÌÈÕÌÅ PU SYSTEMUSER COMSCONTROL CANDECONTROL CANDEGETMSG PWMIGRATION = 1 like User MAXPW MINPW NEWPASSLIST Administrator |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert text into columns
Data - Text to Columns - Delimited - Custom, type "=" without the quotes.
"aquaflow" wrote: USER = ADMINISTRATOR MAXPW = 1 MINPW = 1 NEWPASSWORDLIST = PASSWORD = ?ÅÎßÃÞÆÌÌÈÕÌÅ PU SYSTEMUSER COMSCONTROL CANDECONTROL CANDEGETMSG PWMIGRATION = 1 like User MAXPW MINPW NEWPASSLIST Administrator |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert text into columns
For the sake of example assume that the data resides in columns A and B
Select the data in column A and press <Ctrl + C to copy the data Right click on cell C1 and select PASTE SPECIAL from the short cut menu, click the TRANSPOSE check box and then click the OK command button to exit the dialog box Select the data in column B and press <Ctrl + C to copy the data Right click on cell C2 and select PASTE SPECIAL from the short cut menu, click the TRANSPOSE check box and then click the OK command button to exit the dialog box You can now delete the data in the original columns. -- Kevin Backmann "aquaflow" wrote: USER = ADMINISTRATOR MAXPW = 1 MINPW = 1 NEWPASSWORDLIST = PASSWORD = ?ÅÎßÃÞÆÌÌÈÕÌÅ PU SYSTEMUSER COMSCONTROL CANDECONTROL CANDEGETMSG PWMIGRATION = 1 like User MAXPW MINPW NEWPASSLIST Administrator |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert text into columns
On Sep 25, 4:50*pm, Kevin B wrote:
For the sake of example assume that the data resides in columns A and B Select the data in column A and press <Ctrl + C to copy the data Right click on cell C1 and select PASTE SPECIAL from the short cut menu, click the TRANSPOSE check box and then click the OK command button to exit the dialog box Select the data in column B and press <Ctrl + C to copy the data Right click on cell C2 and select PASTE SPECIAL from the short cut menu, click the TRANSPOSE check box and then click the OK command button to exit the dialog box You can now delete the data in the original columns. -- Kevin Backmann "aquaflow" wrote: USER = ADMINISTRATOR * * * * * MAXPW = 1 * *MINPW = 1 * * * * * NEWPASSWORDLIST = * * * * * PASSWORD = ?ÅÎßÐÞÆÌÌÈÕÌÅ * * * * * PU * * * * * SYSTEMUSER * * * * * COMSCONTROL * * * * * CANDECONTROL * * * * * CANDEGETMSG * * * * * PWMIGRATION = 1 like User * * * * * * * * * MAXPW MINPW NEWPASSLIST Administrator can a macro help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert text to columns | Excel Discussion (Misc queries) | |||
| Convert text to columns | Excel Worksheet Functions | |||
| Convert text to columns | Excel Discussion (Misc queries) | |||
| convert text to columns | Excel Discussion (Misc queries) | |||
| How do I convert text to columns when there is a carriage return? | Excel Worksheet Functions | |||
Hybrid Mode
