Related Posts
How is the job security in @Capco.@Capco
looking for referrals at RBC BMO
What’s going on with pypl and sq???
Additional Posts in Excel Genius
What are the most typical models you all build
I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?
New to Fishbowl?
unlock all discussions on Fishbowl.
Alt H N S?
OP, did you need me to add ‘Enter’ to my post? Or did you know what to do after hitting Alt H N S?
alt + H + N + S
Ctrl + ;
Yup, this is it on my machine.
A little more involved, but you can create the following VBA code:
Sub FormatDate ()
Selection.NumberFormat = “mm/dd/yyyy”
End Sub
Then customize the ribbon with a new group and add the macro to it.
From then on, any cell(s) that are selected will be formatted correctly by clicking the new icon on the ribbon.
alt f4 y
OmG sO fUnNy KPMG