| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract last name and insert into a different field.
THANK YOU! I DON'T KNOW WHAT I DID BEFORE. PERFECT!
"Ron de Bruin" wrote: Hi v Try it on a new sheet and you see that this is not the problem of the function -- Regards Ron de Bruin http://www.rondebruin.nl "Barb" wrote in message ... If I put the formula in B1, the last name appears in B1 but C1 becomes a merged cell with B1 and both cells have a dark grey background. "Ron de Bruin" wrote: Works great except it uses up two lines for the answer & it has a grey background. I do not understand you ? -- Regards Ron de Bruin http://www.rondebruin.nl "Barb" wrote in message ... Works great except it uses up two lines for the answer & it has a grey background. "Ron de Bruin" wrote: Hi Barb Try this formula with the name in A2 =IF(ISERR(FIND(" ",A2)),A2,MID(A2,FIND("^^",SUBSTITUTE(A2," ","^^",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))+1,1024)) -- Regards Ron de Bruin http://www.rondebruin.nl "Barb" wrote in message ... I want to extract a person's last name from a field & put it into another for sorting purposes. If their name is Bud Line, I want to put Line into a different field. If their name is Betsy Sue Color, I want to put Color into a different field. I think their should be a way to search for the space starting from the right side, but I don't know how. The problem I'm having is if their name is listed as first, middle and last. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
