How to convert word into number

[Inacio11]

Hi,

I'm trying create unique ID's based on some arguments, such as: date, value, name:
Date: 04/01/2019
Value: -10,13
Name: SKEMA

** Which formula I should to use to convert the word "SKEMA" into a number ? And which formula I could to use to generate a code based on these elements ?
Thanks !

 

[arunsjain]

Hi,

you can use TEXTJOIN function like =TEXTJOIN("_",TRUE,C5:C7). Outcome will be 43469_-1013_SKEMA. It will create a unique id for each row.

Cheers!!!

 

[panyagak]

Hi.

I have the answer BUT clarify these issues TO GET PROPER RESPONSES:

Where are these Dates, Values, Names?? in one cell OR different cells??

From the 3, HOW DO YOU WANT your code to look like?? ( Date-Value-Names, Date Value Names etc)??

 

[panyagak]

ASSUMING: DATE, VALUE, NAME ARE IN CELLS A2, B2 & C2 in that order,
Simply CONCATENATE As:

=A2&" - "&B2&" - "&C2

(Change" - " TO SUIT YOUR EXPECTATIONS)

 

[Inacio11]

Hello all
Thanks for the support. The proposals gave me ideas to solve the issue. Thanks very much !
Jeferson