Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Re-arranging name fields
Hi,
I need help in re-organising name field, which is presently in lastname, firstname followed by employee id format into firstname lastname format. For eg, i have 'Was,Yu Wah 1320 0' I need this to be re-arranged as 'Yu Wah Was' The problem is not all the employees have two first names. So , there are cases where the name is like 'Was,Yu 1340 0 ' and this is to be arranged as 'Yu Was' Is this possible? Regards Govind. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table # of fields | Excel Discussion (Misc queries) | |||
Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
Not including blank fields in pivot tables | Excel Worksheet Functions | |||
Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) |