Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert Number Store as Text in excel to Number in Alteryx

rohit782192
11 - Bolide
'782192

 

How can we convert Number store as Text to Number in Alteryx. In Excel we can do but we can cover in Alteryx.

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

ToNumber(ReplaceChar([Field], "'",""))

alexnajm
18 - Pollux
18 - Pollux

I see the like - make sure you also accept the response as a solution to close the thread and ensure other people know it was a useful response. Thanks in advance!

Labels
Top Solution Authors