Ask Your Question
0

Is there a way that in the Text Substitute can be done more than once? [closed]

asked 2013-11-14 21:49:47 +0100

AisIceEyes gravatar image

updated 2015-09-10 10:56:07 +0100

Alex Kemp gravatar image

Is there a way that in the Text Substitute can be done more than once?

For example, I want to convert the text "1234567890" to "LIBREFORTW" where there is like a one-on-one mapping of the number to a corresponding letter, like these:

1 : L
2 : I 
3 : B
4 : R
5 : E
6 : F
7 : O
8 : R
9 : T
0 : W
edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-14 15:16:09.720935

1 Answer

Sort by » oldest newest most voted
0

answered 2013-11-14 23:19:56 +0100

m.a.riosv gravatar image

How do you want to do?, with a formula or with Find&Replace?
Are all numbers of "1234567890" in one cell, or is every number in one cell?

edit flag offensive delete link more

Comments

I tried Find&Replace and it worked. Thanks! :D

AisIceEyes gravatar imageAisIceEyes ( 2013-11-15 07:09:19 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2013-11-14 21:49:47 +0100

Seen: 49 times

Last updated: Nov 14 '13