June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.
Course Of The Month
3 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
how can i remove a Z letter in a string
Posted on 2012-12-20
hi
someone know a function to remove letter Z from 3th clolumn
so , by example, string NF114Z must change to NF114, NF102Z must change to NF102
01NAEB NC31 NF114Z SYSGERMX02 19/12/2012 111400
13IMBC NC31 NF102Z SYSGERMX02 19/12/2012 111400
20NAGB NC31 NF90Z SYSGERMX02 19/12/2012 111400
21NACA NC31 NF100Z SYSGERMX02 19/12/2012 111400
23NADA NC31 NF116Z SYSGERMX02 19/12/2012 111400
23NAEB NC31 NF115Z SYSGERMX02 19/12/2012 111400
27NAEN NC31 NF82Z SYSGERMX02 19/12/2012 111400
29NACA NC31 NF92Z SYSGERMX02 19/12/2012 111400
29NAFB NC31 NF93Z SYSGERMX02 19/12/2012 111400
31IMBL NC31 NF103Z SYSGERMX02 19/12/2012 111400
44NABD NC31 NF95Z SYSGERMX02 19/12/2012 111400
thanks a lot
EXPORTNC31.csv
someone know a function to remove letter Z from 3th clolumn
so , by example, string NF114Z must change to NF114, NF102Z must change to NF102
01NAEB NC31 NF114Z SYSGERMX02 19/12/2012 111400
13IMBC NC31 NF102Z SYSGERMX02 19/12/2012 111400
20NAGB NC31 NF90Z SYSGERMX02 19/12/2012 111400
21NACA NC31 NF100Z SYSGERMX02 19/12/2012 111400
23NADA NC31 NF116Z SYSGERMX02 19/12/2012 111400
23NAEB NC31 NF115Z SYSGERMX02 19/12/2012 111400
27NAEN NC31 NF82Z SYSGERMX02 19/12/2012 111400
29NACA NC31 NF92Z SYSGERMX02 19/12/2012 111400
29NAFB NC31 NF93Z SYSGERMX02 19/12/2012 111400
31IMBL NC31 NF103Z SYSGERMX02 19/12/2012 111400
44NABD NC31 NF95Z SYSGERMX02 19/12/2012 111400
thanks a lot
EXPORTNC31.csv
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5 Comments
Active today
If that is the only Z in the column, you can select the column, the hold CTRL key, and hit H key (CTRL+H) , then replace Z with nothing in the replace with box.
Click Replace ALL.
if there are other possible Z's, then use a formula in another column like:
=LEFT(C2,LEN(C2)-1) copied down.
Then you can copy this column and go to column C and paste Special > Values over the original. Then delete the formula column.
Click Replace ALL.
if there are other possible Z's, then use a formula in another column like:
=LEFT(C2,LEN(C2)-1) copied down.
Then you can copy this column and go to column C and paste Special > Values over the original. Then delete the formula column.
Since the 'Z' is always there and is alway the final character, you can use the following formula in column D: (put this in D1 and copy down the column).
=LEFT(C1,LEN(C1)-1)
If the 'Z' is not always at the end, you can remove the first Z with this formula:
=LEFT(C1,FIND("Z",C1)-1)&M
=LEFT(C1,LEN(C1)-1)
If the 'Z' is not always at the end, you can remove the first Z with this formula:
=LEFT(C1,FIND("Z",C1)-1)&M
You could simply use Edit > Replace for a range of cells, replace "Z" with nothing.....
or you could use a formula in another column, e.g. with data in C2 put this formula in an empty cell in row 2 and copy down
=SUBSTITUTE(C2,"Z","")
regards, barry
or you could use a formula in another column, e.g. with data in C2 put this formula in an empty cell in row 2 and copy down
=SUBSTITUTE(C2,"Z","")
regards, barry
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation)
David Miller (dlmille)
Synopsis
In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Suggested Courses
Course of the Month3 days, 14 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.