FG

Excel: Replace occurences of one character with another in a String?

Fresh3 days ago
Mar 15, 202683927 views
Confidence Score0%
0%

Problem

I want an excel formula that will change to . (Text is to lowercase, and spaces are replaced with plus characters.) The following will get the first space, but not all of them:

Error Output

Haverford, PA

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel: Replace occurences of one character with another in a String?

Low Risk

Part of what you want to do can be accomplished with the "SUBSTITUTE" function. This will replace specific characters in a text string with the characters you specify, in this case spaces with the + symbol. Then to change case use the "LOWER" functi…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment