| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Lists - Automatically Changing Information
Many thanks everyone - now sorted :-)
Debs "Roger Govier" wrote: Hi Debs Assuming the names are in column A with blank columns to the right Mark column ADataText to columnsDelimitedDelimiterCommaFinish. You now have lastname in column A and firstname in column B. Enter in cell C1 @Dickinson-Dees.com then in D1 enter =B1&"."&A1&$C$1 Copy down column D as far as required. Copy column DPaste SpecialValues to "fix" the data. -- Regards Roger Govier "Debs" wrote in message ... Hi I have a list of names in Excel XP which are formatted as: Rose, Deborah Culyer, Susan What I need to do is get them to automatically change to the following format: Does anyone know of any formulas that would allow me to do this please? Regards Debbie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically import information from webpage into Excel Cell | Excel Discussion (Misc queries) | |||
| Automatically changing cell information | Excel Discussion (Misc queries) | |||
| Sorting information into lists | Excel Discussion (Misc queries) | |||
| Excel Changing Numbers Automatically | Excel Discussion (Misc queries) | |||
| Changing case on mailing lists I receive in Excel 2003? | Excel Worksheet Functions | |||
Threaded Mode
