Have Calc cells or column take input and convert to uppercase on the fly

How might I format one column of text-entry cells to act as if the CAPS LOCK KEY were turned on, while in adjacent columns it isn’t, while entering data into a spreadsheet in LibreOffice Calc?



9/3/2013 | 2023 | wa5xyz | Somewhere, OK | Jake


09/03/2013 | 2023 | WA5XYZ | Somewhere, OK | Jake

I use the pipe symbols | for indicating cell boundaries.

My first place to look for the feature was in the Format Cells dialog under Font Effects (outline, shadowing, overlining, underlining, strike-through) or under Font (Language: English and other choices), then Alignment.

I have chosen a slashed-zero font for use in the call sign column, so that rules out my choosing an all-capitals font, unless there is a suitable one with a slashed zero.

Help was of little help, as it offered up the UPPER function with its cryptic explanation of how to use it. Upper function doesn’t look like the proper means of locomotion to use for this job.

Any ideas? Thanks in advance!

LibreOffice Calc:  Version:
Build ID: 1c1366bba2ba2b554cd2ca4d87c06da81c05d24

From the Calc Help menu’s About LibreOffice page.

Microsoft Windows XP
Home Edition
Version 2002
Service Pack 3

From My Computer, Properties

Perhaps not the solution, but I think Menu/Format/Change case after selecting the column can be a quick way to do it.