Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am looking to extract everything on the right of a " " (space) in a text
line. I have a lit of names in the form of FN" "LN in column A. In column B I want to extract the LN portion of column A. I guess the next logical question would be if I extract the LN and it is in column B can I compare column A to B and output the difference in column C stripping off the extra space after the FN? TIA Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |