Forum Discussion

MichaelGraham2's avatar
MichaelGraham2
Qrew Assistant Captain
9 years ago

Excel advice on how to prepare excel to import into Multi Select field in QuickBase

I currently have an excel sheet with recordID and Features columns In the record ID I have the same number multiple times and in Features I have the different options. To Import this into QuickBas...
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
9 years ago
Like this:

=A1 & ";" & B1 & ";" & C1

MichaelGraham2's avatar
MichaelGraham2
Qrew Assistant Captain
9 years ago
It looks like I would have to type in that for each record.   Ive got 2000 records.
I could just as well export it them to a text file and manually add the ; between the text :(