FG
💻 Software

How to search & replace within a cell value?

Fresh5 days ago
Mar 15, 20269150 views
Confidence Score0%
0%

Problem

I have a cell A and its value is . In another cell B, I want its value to be the value in cell B but all should be replaced by - value in cell B should be . What is the function to use in this case?

Error Output

122abb12

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to search & replace within a cell value?

Low Risk

I believe you are looking for the Substitute function:

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment