Excel formula to replace or stubstitute only text that starts with a certain letter

0 votes

Prior
Rlet
Rcall
Resolved

So I want Excel to find and replace all words starting with "R" in a certain column and change them all to "Resolved". It seems like a simple substitute or replacement, but I can't seem to get it to work with only words starting with "R". 

5 days ago in Others by Kithuzzz
• 20,660 points
34 views

1 answer to this question.

0 votes

You're requesting a "formula." Normally, you would enter that into a cell. In such a situation, you might enter the following formula in cell B1 if you have the list of terms in the A column:

=IF(LEFT(A1, 1)="R", "Resolved", A1)

If the first letter in A1 is A, "Resolved" will be added to B1, otherwise, A1 will be copied.
Now that column A is hidden, you can copy this equation down by double-clicking the tiny square in the bottom right corner of the cell. You might also copy column B in its whole, "paste special... Values only," onto column A, then remove column A.

answered 5 days ago by narikkadan
• 37,660 points

Related Questions In Others

0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
199 views
0 votes
1 answer

How to install a GUI on Amazon AWS EC2 or EMR with the Amazon AMI

The top-level script for installing the GUI ...READ MORE

answered Mar 9 in Others by gaurav
• 22,040 points
96 views
0 votes
1 answer

Convert csv- or Excel-file (xlsx) to kml with custom markers

With some help from the community, I ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
86 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
137 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
230 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
101 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
68 views
0 votes
1 answer

Text with a dash in the cell but not in the formula bar (Excel)

What you have got here is called ...READ MORE

answered Nov 13 in Others by narikkadan
• 37,660 points
24 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
56 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP