| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to separate fname and fname in cell in excel
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to separate fname and fname in cell in excel
Sub AABA()
Set cell = ActiveCell If InStr(cell, ",") Then iloc = InStr(cell, ",") cell.Offset(0, -1).Value = Left(cell.Value, iloc - 1) cell.Value = Right(cell.Value, Len(cell.Value) - (iloc + 1)) End If End Sub -- Regards, Tom Ogilvy "Excel Problem" <Excel wrote in message ... Can soneone help me to wright a formula that will separate lname and fname in cell "B" to Cell"A "=lname and cell"B"=fname. Thy are separate by comma and space in cell "B" in excel 2000. My e-mail address is |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to separate fname and fname in cell in excel
datatext to columns is probably the easiest
or a macro -- Don Guillett SalesAid Software "Excel Problem" <Excel wrote in message ... Can soneone help me to wright a formula that will separate lname and fname in cell "B" to Cell"A "=lname and cell"B"=fname. Thy are separate by comma and space in cell "B" in excel 2000. My e-mail address is |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create user id fm LName, FName | Excel Worksheet Functions | |||
| multiple file uploading - runtime error'13': type mismatch "While Counter <= UBound(FName)" | Excel Discussion (Misc queries) | |||
| change lname, fname to fname last name | Excel Discussion (Misc queries) | |||
| how do i reference data in a file with the fname in another cell? | Excel Worksheet Functions | |||
| Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
Linear Mode
