Thread: [Solved] Add _ based on a calculated colums
View Single Post
 
Old 03-09-2012, 07:23 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows XP Office 2003
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
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
Reply With Quote