Fill with custom list.

[Silvia755]

How can i use fill function with custom lists in excel?

I have a list of names that I need to defer to other text by creating a serial list,

Can anyone help me?

Thanks

[#2]

HI @Silvia755 

Assume you have a list of names in column A

You can define the custom list by following the below steps:

File > Option > Advanced > General > Edit Custom List > NEW LIST > Link the range > Import > OK

Once you have defined the list, open a new excel workbook, just write any name from the list and simply drag it. The fill function will auto-generate the custom list.

Hope it will help.

Thanks

Tauqeer

[#3]

@tauqeeracma Thank you very much!

Unfortunately, my question is more complex. If I write the name in an empty excel box the program creates a series, correctly.

However, if in a box I write text, like "financing" and then I write the first name of the list, and drag, the series is not created.

Il the list is:

Enterprise X

Enterprise XX

Enterprise XXX

Enterprise IV

I'd want to make automatically a column like this:

A	B
1	financing Enterprise X
2	financing Enterprise XX
3	financing Enterprise XXX
4	financing Enterprise IV

Can you tell me why or give me advice on how to make it?

Thanks a lot!

[#4]

Hi @Silvia755 

The quick workaround for your requirement is to keep your Names in a separate column and use another column to write the additional text.
Finally, you may combine both columns using CONCATENATE() or TEXTJOIN() functions to get the desired result.

See the sample file.

Hope it will help.

Thanks

Tauqeer