Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

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
0
CMILLER
Asked:
CMILLER
  • 2
1 Solution
 
NBVCCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now