texasalynn
Well-known Member
- Joined
- May 19, 2002
- Messages
- 8,458
I have a file with a list of names and some have a number with the name. I need to find a way to take off the number.
For example I will have
Aldi #6076
or Aldi Grocery 9711
I want
Aldi
Aldi Grocery
The only common thing about the data is that the name is first and the numbers are at the end.
Any ideas?
Thanks
texasalynn
For example I will have
Aldi #6076
or Aldi Grocery 9711
I want
Aldi
Aldi Grocery
The only common thing about the data is that the name is first and the numbers are at the end.
Any ideas?
Thanks
texasalynn