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:
Scumpa85 pe Simpatie.ro

Femeie
24 ani
Bucuresti
cauta Barbat
27 - 45 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] Replace 1 character with another (substitute)

Pagini: 1

Moderat de TRaP, TonyTzu

TonyTzu
Moderator
Postari: 252

Problem:
you have 1.2.3.4 and want to transform it to _1_2_3_4:

Answer:
="_"&SUBSTITUTE(B1;".";"_")

Mrrrr
AdMiN
Postari: 2388

To substitute multiple characters either use multiple SUBSTITUTE and INDEX functions or use VBA with a custom function:
http://mrrrr.3xforum.ro/post/2011/EXCEL ... FUNCTION_/

_______________________________________

Pagini: 1

Mergi la