Find Multiple Values, Replace With Single Value

[gyaeger]

Looking for a solution to doing multiple find and replacements.

Basically I have cell values 1, 2, 3, 4 and so on. I want to replace them all as L.

Find 1 replace with L
Find 2 replace with L

and so on....


Is there a way to find multiple values, and replace all with L? Or can I find ALL Numeric values and replace all with L?

Thanks in advance.

 

[pplstuff]

Why don't you just type L into the cell and drop it down?

Perhaps you can explain the problem better. How are you data stored? Is there only one number in a cell or is there a text string?

Post a sample.

 

[gyaeger]

The problem is I need the blanks to stay blank. (pardon my display, too many restrictions on my work computer)

Imagine these are cells. My pivot table returned the number of occurrences, 0=blank. Essentially I need it to read either blank, or occurence. So I only want to see if there ARE occurences, and not how many. Since the tables were already made and sent to me, I just need to replace the data, and combine with other tables, but the numbers go from 1-100s so I didn't want to have to do it one at a time.

Does that help at all? haha Let me know if I could explain better.

1
1	3	1	1
2	4	2	2
	3	1	1
1

<colgroup><col style="width: 48pt;" span="4" width="64">
<tbody>


</tbody>

 

[pplstuff]

in the worksheet area next to where you are doing this, why not try this:

I'll assume from the above data that your data is four columns (say a:d) starting in a1:

e1: =if(isblank(a1),"","L")
Drag and drop this formula across an equally sized matrix, then copy/paste special/values to eliminate the formula.

You could of course upgrade the formula to have some error handling. But if you want a single character, then it should work fine.

 

[gyaeger]

That is fantastic. Worked perfectly. Thank you so much. I was so set on working through Find and Replace that I never even thought about using another function haha.

Thank you!