Site Forum

This forum is for posting of topics related to this site.

Inappropriate messages may be deleted. See forum rules for details.

Checklists and Excell

Posted By

Message

capsboy

Posts: 64
Joined: Feb 2012

Monday, April 16, 2018 2:40 PM

Some of you may know this but I have been using Excell for years and this new to me, so I thought I would share.

If the checklists you find to copy/paste into an Excell sheet list player names in all capital letters use =PROPER(cell ref) to copy the cell contents into a new cell with the correct upper and lower case letters.

Just remember to copy and "paste special - contents only" into a third cell to remove the formula and get text only. Works in OpenOffice also. NO MORE TYPING!

Splinter_9

Posts: 743
Joined: Sep 2013

Monday, April 16, 2018 3:42 PM
Works in LibreOffice too. Thanks for the tip ------------------------------- A man has to have goals — for a day, for a lifetime — and that was mine, to have people say, "There goes Ted Williams, the greatest hitter who ever lived."

tonym

Posts: 1,192
Joined: Jan 2012

Monday, April 16, 2018 4:57 PM
i love excel myself, the concatenate function and Text to columns saves a whole lotta time. i made a video for it that i shared a few times -------------------------------

Site Forum

Checklists and Excell

Account

Browse

Features

Resources

General Info