Last post Sep 25, 2014 09:59 PM by Kevin Shen - MSFT
Sep 25, 2014 09:04 AM|vignesht5|LINK
I am very new to MS Access. I have list of
names like this in a column in my access and would need to trim the names like
Clooney, George Timothy
I need to have the first word before and after the comma. Also on top of this I need to add a space after comma.
Really appreciate suggestions.
Sep 25, 2014 09:59 PM|Kevin Shen - MSFT|LINK
If you want to the first word before and after the comma,
The expected Output for your second row should be:
If I misunderstand you, please elaborate your question more exactly.