Allow user to write Part of string and number only - data validation list

[jaryszek]

Hi,

I want to allow users to input only word "TOPIC" plus number.
So for example: TOPIC1, TOPIC12, TOPIC13.

It is possible to write specific formula in data validation list?

Best,
Jacek

[FDibbins]

Not sure I understand what you want?

1st, DV can ONLY contain text, not formulas, it functions exactly the same as manually entering data.

[jaryszek]

Hi FDibbins,

thank you.

User has to write only "TOPIC1" text into cell with data validation.
Or TOPIC12, TOPIC2, TOPIC3, TOPIC1453 text.

Can i do it with data validation?

Jacek

[kersplash]

Can you just get the user to enter a number and then use a formula to concatenate the word TOPIC onto the front of it?

[samba_ravi]

If want to apply data validation in A1 then try like below

=AND(LEFT(A1,5)="Topic",MID(A1,6,10)+0>0)

[jaryszek]

I could but word TOPIC should be seen by users.

And this is within table so it should be all visible to users.

Jacek

[samba_ravi]

@ jaryszek, whom you are addressing

[jaryszek]

Wow thank you nflsales

IT is working!

How can i apply it to dynamic table?
To refer only to actual row and first column?

Best,
Jacek

[samba_ravi]

Apply in a cell then copy & Paste towards down

[jaryszek]

Ok thank you,

can i do it using references to structered tables?

Jacek

[samba_ravi]

I think can do it

[jaryszek]

How ?

I was trying to use =LEFT("tablename[#This Row]";5)="Topic" but this is not working...

Jacek

[samba_ravi]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.