Forum Discussion
Fill with custom list.
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!
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