I am trying to clean up data for a chatbot we are programming for school and I need to move the #'s from column c and insert them into column d so they would look like this.
Current
botPref = ("genus")
Desired
botPref004 = ("genus")
Is there a couple of steps or will this be "oh hey you could try this"
Thanks in advance for your help.
Screen Shot 2016-05-24 at 2.57.49 AM.png
Try this ...
=SUBSTITUTE(D2,"botPref","botPref"&TEXT(C2,"000"))
Last edited by Phuocam; 05-24-2016 at 07:11 AM.
Hi excelstone,
Try this in cell E5.
=IF(C6<10,"botPref"&"00"&C6&" "&MID(D6,9,100),"botPref"&"0"&C6&" "&MID(D6,9,100))
NB - It will only work up to 99 lines of data. How many are you working with?
Snook
Snook, now that the cells are uniform I need to take a "cold snapshot" of the columns.
For example if I copy E column and paste it the calculation disappears... there is a copy or paste feature like that.
Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Are you saying you want to copy the values the formula created ?
If so then select pasteSpecial and click "values"
Hi excelstone,
Like nimrod says it sounds like you need to copy and paste value your formulas to hard code them, i.e. convert them from formulas into actual text. To do this select the range to be converted (presumably from E2 down to the bottom of the range), copy them (ctrl + c) and then paste them on top of itself as a value (ctrl + alt + v to display the paste special dialog box then select 'values' and press ok).
Regards,
Snook
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks