Add _ based on a calculated colums

		Microsoft Office Forums > Microsoft Excel > Excel
Add _ based on a calculated colums

FAQ

Thread Tools

Display Modes

03-09-2012, 07:23 AM

Pecoflyer

Windows XP Add _ based on a calculated colums

Office 2003

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Don't know if it works on mac but you will get the idea

Code:

=LOWER(CONCATENATE(J75,RIGHT(E75,2),LEFT(C75,MIN(4,LEN(C75)),REPT("_",4-LEN(C75)),LEFT(A75,1)))

EDIT corrected formula missing parenthesis

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Work calculated differently for two seemingly identical tasks	SteveD	Project	0	10-12-2011 02:05 PM
Calculated Field is disabled	MariaAdc	Excel	1	03-01-2011 02:44 AM
Calculated dates.	Ziggy-R	Word	10	09-28-2010 01:42 AM
multiple colums under a single column	RobotChicken	Excel	3	01-06-2010 09:17 AM
Using calculated field - WHY IS IT SO COMPLICATED?	Riorin	Word	0	10-30-2009 12:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:54 AM.