Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 01-09-2017, 03:36 PM
b16 b16 is offline Concatenate Windows 8 Concatenate Office 2010 32bit
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)”

Col A
Col B

=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
Old 01-09-2017, 04:51 PM
jeffreybrown jeffreybrown is offline Concatenate Windows Vista Concatenate Office 2007
Join Date: Apr 2016
Posts: 611
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about

Why not just use a custom format in Column A of 000000000
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate concatenate the currency too isasa74 Excel Programming 24 12-20-2015 06:01 AM
Concatenate Use Two (concatenate) Fields If Condition Is Met (If... Then... Else) SoonerLater Mail Merge 1 09-30-2015 05:40 PM
Concatenate Concatenate with @ symbol anickles Excel 2 02-06-2015 09:39 AM
Concatenate 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:59 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft