concatenation

  • Thread starter Thread starter Julmau
  • Start date Start date
J

Julmau

Hello,

tough for me, easy for you?

I have a list of file numbers in A1 (152,EF251,TG2004-156,ect.) in
worksheet-1 in workbook1.

What would the solution to automatically create (and then update from
worksheet(n) in workbook1) a column in worksheet1 in workbook2 in which
each file number is extracted and copied in a single cell (B1=152,
B2=EF251, B3=TG2004-156, ect.)?

Thank you for your help

Julmau
 
I wold just copy and paste the cell from Workbook1 to Workbook2 and then do
Data > Text to columns, using the comma as the delimiter to separate the
values into subsequent columns.

Vaya con Dios,
Chuck, CABGx3
 
Hello Chuck

Thank you for your so helpful answer. I found the way too to get th
data in a single row after using your "trick" to put them in a column.

I will now look for a way to AUTOMATICALLY increment this kind o
database with every new input. If anybody has any insights......

Thanks again, Chuck

Julma
 
Back
Top