#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Why not just use a custom format in Column A of 000000000
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
concatenate the currency too | isasa74 | Excel Programming | 24 | 12-20-2015 06:01 AM |
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else) | SoonerLater | Mail Merge | 1 | 09-30-2015 05:40 PM |
Concatenate with @ symbol | anickles | Excel | 2 | 02-06-2015 09:39 AM |
Concatenate if in descending order | pgeorgilas | Excel Programming | 2 | 12-10-2014 01:35 AM |
If, move and concatenate in VBA | devcon | Excel Programming | 0 | 07-04-2011 12:44 AM |