Concatenating two ranges in data validation

		Microsoft Office Forums > Microsoft Excel > Excel
Concatenating two ranges in data validation

04-19-2025, 07:20 AM

MartinGM

Windows 11 Concatenating two ranges in data validation

Office 2021

Competent Performer

Join Date: May 2023

Location: England

Posts: 108

Thanks Pecover. That's very simple, and takes care of the varying size of the concatenated range

I hadn't seen the # suffix before - what does it do ?
Martin

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Validation	firozmohammed	Excel	4	11-18-2023 01:55 AM
Copying and Concatenating data in excel based on a value in another column	BoardingSUP	Excel Programming	5	10-17-2021 08:05 AM
Need to copy specific ranges column data as row data from one worksheet to another using excel VBA	ganesang	Excel Programming	1	03-26-2020 06:18 AM
Data Validation List based on Two Named Ranges	Rich18144	Excel	4	01-14-2016 04:37 AM
Data validation with IF	Klyxrastafari	Excel	1	10-03-2011 04:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:19 AM.