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

gebobs · #1 09-29-2014, 09:52 AM

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)

Sonataarctica2301 · #2 10-01-2014, 01:42 AM

Thanks gebobs,

I had to change it to reference cell C3 and C36 but it works perfectly! Thank you so much, you're a life saver!!!!

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