Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

excel chane value

How can i change m to w only colum b
0
teera
Asked:
teera
2 Solutions
 
Rory ArchibaldCommented:
Select column B, press Ctrl+h, then enter m in the Find box and w in the replace box, and press Replace All.

HTH
Rory
0
 
zorvek (Kevin Jones)ConsultantCommented:
Select the cells to change and press CTRL+H. Enter "m" in the find field and "w" in the change to field. Click "Replace All".

Kevin
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now