Microsoft Office Forums - View Single Post - Question of data Validation

Thread: Question of data Validation

View Single Post

Old

12-26-2018, 02:59 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

Then what about using

=INDIRECT(SUBSTITUTE($A$1," ",""))

in Data Validation?

Reply With Quote