Chris Miller
asked on
Remove a char from a column Excel 2007
I have a col in a sheet that has an extra char that I need to remove for 400 rows.
The char is a "N" and is at the end of every row in col A. There is also space in between of what I want to keep. There is not set number of spaces in between what I want to keep and the "N". There are different begining words within the 400 rows.
See the attached.
Org-List-by-Group.xlsx
The char is a "N" and is at the end of every row in col A. There is also space in between of what I want to keep. There is not set number of spaces in between what I want to keep and the "N". There are different begining words within the 400 rows.
See the attached.
Org-List-by-Group.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would think so because both the LEFT() function and the LEN() function are available in Access.
ASKER