Bring the "Right" portion of a cells value
If the cell in column A starts with "Section code" and the word does not ends in "-part one", then bring the last word starting from right to left. Place the answer in column c, per row.
Thanks,
JP bring-the-last-word-in-a-cell.xls
Thanks,
JP bring-the-last-word-in-a-cell.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
:) LOLOL
ASKER
Great! Right on target. Going with Jppinto, as it a non-macro solution. Should have specified it.
Thank you both,
JP
Thank you both,
JP
Sid