Hi Everyone,
Hoping to receive some help.
I have a column of data, sometimes its 6 Digits, sometimes 5 digits. I want to do a Concatenate on that row and do (D00,A1) ... and so on. However, with the one's that are 5 digits I want to add an extra 0. so it would be D00012345 and D00123456.
Anyway to create a formula for that?
Thanks for all your help guys!
sorry read it wrong
use if and LEN formula to concatenate
Formula:
Please Login or Register to view this content.
Last edited by humdingaling; 05-21-2014 at 11:39 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Wow thanks for your help!
Lifesaver.
not a problem
Formula:Please Login or Register to view this content.
i think this one might even be better for you
or this...
=IF(LEN(A1)=5,"D000",D00")&A1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks