Replace /- from all cell in excel

-

 To delete the "/-" from all cells in Excel that contain values like "২,০০০/-", you can use Excel's Find and Replace feature. Here's how to do it:

Type-1:

  1. Open the Excel sheet where the data is located.
  2. Select the range of cells where you want to make the change. If it's the entire sheet, press Ctrl + A to select all cells.
  3. Press Ctrl + H to open the Find and Replace dialog box.
  4. In the Find what field, type /-.
  5. Leave the Replace with field empty.
  6. Click Replace All.
Type-2

=SUBSTITUTE(D2,"/-","")

Type-3 (also convert text to number)

=VALUE(LEFT(D2,FIND("/",D2)-1))



Comments

Post a Comment

Popular posts from this blog

Basic Web Design with HTML and CSS

-
Image
Webpage A  web page  or  webpage  is a document, commonly written in  HTML , that is viewed in an Internet  browser . A web page can be accessed by entering a  URL  address into a browser's  address bar . A web page may contain text, graphics, and  hyperlinks  to other web pages and files.   WebSite : A website is a collection of several web pages. These pages are linked together with hyperlinks. A website has a unique domain name, and we can access it by entering that domain name in the URL. A domain name is a string of characters that identifies a website. It is what users type in their browser to visit your site.   Web hosting is a service that provides space on a server for your website files, allowing it to be available on the internet. When visitors access your domain name, the hosting provider will transfer those files to their web browsers.   Two types of website Static website ...
Read more

Project Web Design Assignment

-
Image
  Assignment-3 <!DOCTYPE html> <html lang="en"> <head>     <meta charset="UTF-8">     <meta name="viewport" content="width=device-width, initial-scale=1.0">     <title>Employee Information Form</title> </head> <body>     <div style="width:30%; margin: auto;">         <form action="#" method="POST">             <fieldset>                 <legend>Employee Details</legend>                                 <!-- Name Field -->                 <label for="name">Name:</label>                 <input type="text" id="name" name="name" required><br><br>           ...
Read more