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
CMILLERAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
In column B add formula:

=LEFT(A2,LEN(A2)-1)

copied down.

Then copy the column B range and Paste Special >> Values over the original column A range.

You can then delete column B.

This will keep the trailing spaces.
0
 
CMILLERAuthor Commented:
Thanks, that works. Can I use that same formula in an Access 2007 DB? Thats where I pull the xls from?
0
 
NBVCCommented:
I would think so because both the LEFT() function and the LEN() function are available in Access.
0
All Courses

From novice to tech pro — start learning today.