Oct 06 2020 11:13 AM
Oct 06 2020 11:31 AM
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. So you could get a precise solution much faster. This would also be a blessing for us, as we can understand the problem much better, a win-win situation for everyone.
* Knowing the Excel version and operating system would also be an advantage.
Not the less I would like to try to give you some information about the possible possibilities.
One possibility could be VBA
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Or Target.Column <> 6 Then Exit Sub If InStr(Target, ",") > 0 Then Application.EnableEvents = False Target = Replace(Target, ",", "") Application.EnableEvents = True End If End Sub ' You just have to change the columns / cells according to your needs.
A second possibility is to try a formula, here is an example (which you should also adapt):
Here's a simple formula that will get the job done correctly: = LEFT (NN, SEARCH ("", NN) - 1)
where NN is the cell that stores the name.
The -1 is there to remove the extra space or comma at the end of the string.
Thank you for your understanding and patience
I would be happy to know if I could help.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.