How to create an account number based on partials from 2 fields

		Microsoft Office Forums > Microsoft Excel > Excel
How to create an account number based on partials from 2 fields

FAQ

Thread Tools

Display Modes

09-29-2014, 09:52 AM

gebobs

Windows 7 64bit How to create an account number based on partials from 2 fields

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

This formula works kind of:

=UPPER(IF(LEFT(D4,4)="THE ",MID(D4,5,3),LEFT(D4,3)))&DAY(D36)&MONTH(D36)

except it only displays one digit if the day or month is less than 10. This can be worked around with a few ifs:

=UPPER(IF(LEFT(D4,4)="THE ",MID(D4,5,3),LEFT(D4,3)))&IF(DAY(D36)<10,"0","")& DAY(D36)&IF(MONTH(D36)<10,"0","")&MONTH(D36)

Tags

formula

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create a table with a number of line depending a number entered by user	Cellendhyll	Word Tables	3	07-10-2014 05:49 AM
Maximum Number Of Styles-Based-On?	Pluviophile	Word	13	05-08-2014 05:29 AM
(ask) unable to create account	jackyjacky88	Outlook	1	04-06-2014 09:10 PM
Error: 'Cannot redeem this offer based on how your Microsoft account is setup'	Laylo	Office	0	08-10-2013 12:49 AM
Outlook 2007 cant create new account	colinwill	Outlook	0	01-30-2013 12:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 AM.