Thread: [Solved] Concatenate
View Single Post
 
Old 01-09-2017, 03:36 PM
b16 b16 is offline Windows 8 Office 2010 32bit
Novice
 
Join Date: Jan 2017
Posts: 1
b16 is on a distinguished road
Default Concatenate

I have the following issue:
In .xls I have the “column A” where users fill figures, usually having less than 9 characters. But, I need 9 characters length figures. To solve that I might use a second column, named “Column B”, where the figures from “Column A” wmay be increased by using the following forms:

“=Right(Concatenate(“000000000”;Column A);9)”

e.g.
Col A
Col B
123456
=Right(Concatenate(“000000000”;Column A);9)=000123456

But I’d really like to achieve the same results without the aid of “Column B” and said function, just using “Column A” and “Data validation”.

Does anyone know how to do it?


Thank you
Reply With Quote