• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Question for Excel users

D

Dudd

Platinum Member
I have a column full of numbers that have some other characters after them. For example,

2000-HYT
2001-HYT
etc.

Is there any way in Excel to delete the final 4 characters from every entry in the column without having to do each one individually? It is very tedious to delete those things several hundred times in a row. Thanks.
 
Originally posted by: minendo
Edit ---> Replace
Click to expand...

Doh, don't even know why I didn't think of that. And to werk, I don't care. 99% of the crap in OT is pointless, and here I got an answer in seconds. In Software, it might have taken hours, if anyone even replyed. So,
rolleye.gif
.
 
Originally posted by: Izzo
Macros are useful when making repetitive keystokes.
Click to expand...

I'm copy and pasting stuff from a webpage into an Excel document. I'm not actually typing anything, just copy-paste, copy paste.
 
I would use a macro to delete the 4 characters after every entry in Excel though. How would you use the Replace function in Excel to delete the last 4 characters? What if the stuff you want to keep or delete is not the same?

edit: added "or delete"
 
Originally posted by: Dudd
I have a column full of numbers that have some other characters after them. For example,

2000-HYT
2001-HYT
etc.

Is there any way in Excel to delete the final 4 characters from every entry in the column without having to do each one individually? It is very tedious to delete those things several hundred times in a row. Thanks.
Click to expand...


here we go: Assuming cell A1 contains "2000-HYT":

1. insert a empty column to the right of column 1
2. in cell b1, type in the formula "=left(a1,4)"
3. copy b1 down the column to revise the rest of your dataset

 
Originally posted by: Shortcut
Originally posted by: Dudd
I have a column full of numbers that have some other characters after them. For example,

2000-HYT
2001-HYT
etc.

Is there any way in Excel to delete the final 4 characters from every entry in the column without having to do each one individually? It is very tedious to delete those things several hundred times in a row. Thanks.
Click to expand...


here we go: Assuming cell A1 contains "2000-HYT":

1. insert a empty column to the right of column 1
2. in cell b1, type in the formula "=left(a1,4)"
3. copy b1 down the column to revise the rest of your dataset
Click to expand...


this is the best way.
 
You must log in or register to reply here.
Back
Top