Chapbass
Diamond Member
Hey all, in a bit of a bind, wondering if someone can help me out. Here's what im trying to do.
I have an existing spreadsheet list of employees. These fields include first name, last name, email, phone number, etc.
I'm trying to use concatenate to create a separate sheet that gives me the dsadd user command for active directory with the right parameters to mass add users.
Now, the concatenate portion works great, I can do all that, been working fine. however today I wanted to add some additional fields. What happened was I reached the end of the 255 character limit in one cell of my spreadsheet. When I went to save that page as a batch file like i normally do, it cut off any character after 255. I've been saving it as a space separated variables file, so I originally thought "hey, ill just take the 2nd half of my concatenate command and put it in cell B2 (my original is in A2), put the space in a convenient spot, and it will just tack it on at the end of that line."
Nope, it puts it on all the lines AFTER A2, A3, A4, etc.
Anyone know how I could take two cells (a2 and b2) and merge them into a single string when I change this to a batch file? or anything else of the like?
My source file doesn't have any customer info in it, so I can upload it to someone upon request.
Thanks!
I have an existing spreadsheet list of employees. These fields include first name, last name, email, phone number, etc.
I'm trying to use concatenate to create a separate sheet that gives me the dsadd user command for active directory with the right parameters to mass add users.
Now, the concatenate portion works great, I can do all that, been working fine. however today I wanted to add some additional fields. What happened was I reached the end of the 255 character limit in one cell of my spreadsheet. When I went to save that page as a batch file like i normally do, it cut off any character after 255. I've been saving it as a space separated variables file, so I originally thought "hey, ill just take the 2nd half of my concatenate command and put it in cell B2 (my original is in A2), put the space in a convenient spot, and it will just tack it on at the end of that line."
Nope, it puts it on all the lines AFTER A2, A3, A4, etc.
Anyone know how I could take two cells (a2 and b2) and merge them into a single string when I change this to a batch file? or anything else of the like?
My source file doesn't have any customer info in it, so I can upload it to someone upon request.
Thanks!
Last edited:
