admin管理员组

文章数量:1125782

Please look at the below table:

Values of L Column are derived from J Column. As for example, value in L3 is =J3.

Problem is there is a slash \ in the value of J Column which is derived from the another worksheet as a part of value (as you can see it means rate/pack) but that slash is not needed in value of L columns. But I can't use the formula LEFT in the L Column cells. So is there any way to hide the slash / from being appeared in L-Column values (Slash may still be there but will not appear, ie Hidden) by Data Validation or something like that type of features?

Please look at the below table:

Values of L Column are derived from J Column. As for example, value in L3 is =J3.

Problem is there is a slash \ in the value of J Column which is derived from the another worksheet as a part of value (as you can see it means rate/pack) but that slash is not needed in value of L columns. But I can't use the formula LEFT in the L Column cells. So is there any way to hide the slash / from being appeared in L-Column values (Slash may still be there but will not appear, ie Hidden) by Data Validation or something like that type of features?

  • excel
Share Improve this question asked Jan 9 at 5:13 Abdullah Mamun-Ur- RashidAbdullah Mamun-Ur- Rashid 6981 gold badge14 silver badges25 bronze badges 6
  • How you are deriving L column value from J column? By formula or any other method? – Harun24hr Commented Jan 9 at 5:24
  • @Harun24hr, as I mentioned in the Question, by the formula, as for example: = J3 – Abdullah Mamun-Ur- Rashid Commented Jan 9 at 5:38
  • Then we can use SUBSTITUTE() function. Try =SUBSTITUTE(J3,"/",""). – Harun24hr Commented Jan 9 at 5:42
  • Why can't use the RIGHT function? Can you show the formula? – Black cat Commented Jan 9 at 5:48
  • @Blackcat I think OP can use RIGHT() function. =RIGHT(J3,LEN(J3)-1). – Harun24hr Commented Jan 9 at 5:50
 |  Show 1 more comment

1 Answer 1

Reset to default 0 
=SUBSTITUTE(text, old_text, new_text)
=SUBSTITUTE(text, "/", "")

本文标签： Is there any way to hide specific character from a cell value in ExcelStack Overflow

版权声明：本文标题：Is there any way to hide specific character from a cell value in Excel - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736671845a1946962.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。