Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • 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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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