markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
Column A of my spreadsheet contains a list of names separated by a comma (i.e Smith, James). Is there a way to easily remove all of the commas as I need to do a VLOOKUP and my lookup sheet does not have commas?
Cheers
Mark
Cheers
Mark