I have well over 500 lines of data to convert into this string
{25442~25442~Bates Security 37~Active~~~}
25442 is the value in the cell, but I need all the other parts to go in as well. This will take me hours to do character by character. Any help is appreciated
Hello & Welcome to the Forum,
With 25442 in A1
B1 ="{"&A1&"~"&A1&"~Bates Security 37~Active~~~}"
HTH
Regards, Jeff
Well that worked, but I didnt think about moving the column. This is CSV that will be imported back into the database of a piece of equipment.
I can only have exact columns and info. So I did your string but if I copy and paste or try to replace the column it grabs the numbers from
it changes my Cell info in that string. Any ideas to get around that
Did you copy and paste "as values"?
Cancel that and thanks jeffreybrown. Paste Values only worked for me
If you want a macro, you could try this on a copy of your workbook. Considers a header in A1
Please Login or Register to view this content.
You are very welcome and thanks for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks