Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.

Nou pe simpatie:
Profil deyutza07

Femeie
23 ani
Buzau
cauta Barbat
25 - 48 ani

Mrrrr's Forum (VIEW ONLY)Reguli Inregistrare Login PozeNu sunteti logat. Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] Remove a specific character from a cell and display the rest

Pagini: 1

Moderat de TRaP, TonyTzu

Mrrrr
AdMiN
Postari: 2388

In cell G15 I have the following strings: *2,15

I want to remove the * and display the number in another cell (for a sum I have to make).

I have to use the following formula:

=SUBSTITUTE(SUBSTITUTE(G15;"*";"");"*";"")

The formula doesn't affect cells which don't contain the * character, displaying their full content.

_______________________________________

Pagini: 1

Mergi la