Removal of characters from a range of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can you remove the last two characters from a range of cells in Excel?
 
You could use the following formula - if the data is in column B enter the
formula in the next column

=LEFT(B5,LEN(B5)-2)
 
You've received a good answer assuming your data might be of inconsistant
string lengths........however, if your data is consistant in nature, like
some part numbers, etc, you might can use either "Find > Replace" or " Data
Text to columns" to perform the action all within the same column.
Click to expand...
If you are interested, post back with a sample of your data in the post (not
attached) and someone will provide more details.

Vaya con Dios,
Chuck, CABGx3
 
Thanks! Perfect.

James said:
You could use the following formula - if the data is in column B enter the
formula in the next column

=LEFT(B5,LEN(B5)-2)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

testing range of cells for part of cell content 5
VBA set thick borders around non empty cells in range 0
Excel Conditional Formatting Removal 7
VLOOKUP, a table with text and numerics 7
Removing first 10 characters of text 2
Adding the total # of characters in multiple cells 3
Macro to Clean Special characters for a Range 5
Restricting Cell entry to certain letters 7

Back
Top