Tag: online spreadsheet course

How to Combine Date and Time in Google Sheets (No Add-ons Needed)

Jun 26, 2025

—

by

Himanshu

in Google Tools Training

📅⏰ How To Combine Date And Time Columns Into One Column In Google Sheets? When working with separate date and time columns, you may need to merge them into a single datetime format. Here’s how to do it effortlessly: ✅ Example Setup A (Date) B (Time) 26/06/2025 10:30 AM You want column C to show:26/06/2025…
How to Get a List of Sheet Names in Google Sheets (Step-by-Step)

Jun 26, 2025

—

by

Himanshu

in Google Tools Training

Google Sheets doesn’t offer a built-in formula to list sheet names directly like Excel VBA might. However, you can achieve it easily using Google Apps Script. Here’s how: ✅ Step 1: Open Google Apps Script ✅ Step 2: Paste This Script In the script editor, paste the following code: javascriptCopyEditfunction listSheetNames() { const ss =…