Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-09-2017, 03:36 PM
b16 b16 is offline Concatenate Windows 8 Concatenate Office 2010 32bit
Novice
Concatenate
 
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
  #2  
Old 01-09-2017, 04:51 PM
jeffreybrown jeffreybrown is offline Concatenate Windows Vista Concatenate Office 2007
Expert
 
Join Date: Apr 2016
Posts: 611
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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

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.
MSOfficeForums.com is not affiliated with Microsoft