Add the same letter as the ending of the word twice at the end of a keyword list
Hi,
I need help to turn a list of keywords, example:
Games
network
website
shock
toys
Into such a list:
Games
networkk
websitee
shockk
toyss
Just basically double the end of the word, I was not sure if this is even possible, but this far i have not come across anything in excel not possible
Please help if you can
Assuming your date is in column A row 2 enter this formula in B2 and fill down the length of your data:
Formula:
Please Login or Register to view this content.
This takes the value in A2 and appends the last character extracted using the RIGHT function. The & joins the value of A2 with the value of the RIGHT function.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Two characters shorter
=A1&RIGHT(A1)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
I am sorry, But i think im to much of a Noob on excel to understand it, This is where i am, as you can see i have started doing it manually, but im afraid it would take a while since the list is over 5k words long http://prntscr.com/7qavmx
Just enter one of the formulas into B1
and copy it down the column
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
So this is where i am... http://prntscr.com/7qb5yl ,
Im probably doing it all wrong, Please see that i almost never use excel thou
I'm not sure what is used where you are located. You may have to use semicolons ; instead of commas , in formulae.
Formula:Please Login or Register to view this content.
So this is where i am... http://prntscr.com/7qb5yl ,
Im probably doing it all wrong, Please see that i almost never use excel thou
Select B1,
enter
=A1&RIGHT(A1)
Press return
Select B1 again
Now copy the cell using Ctrl-C
Now select B2, hold down shift and down arrow until you get to the last ROW of column A
Hit Ctrl-V to copy
tHe formula in B1 is copied downwards for each row of column A.
Sorry for double post
Ends up like this:Originally Posted by Special-K
http://prntscr.com/7qbaal
Please see attached file.
Looks like you've entered the formula incorrectly.
Select B1
Type
=A1&RIGHT(A1)
B1 should now say
webb
If it says anything else like NAME then youve entered it incorrectly.
Once it says webb
copy and paste it down the column as described above
Got it,
Now where in that code would i need to make a change to add the last character twice? or 3 times.
Here is modified formula:
change number 2 (in red) to desired number of repeats.
=A1&REPT(RIGHT(A1),2)
Since my program is german i think i need this in german? =A1&REPT(RIGHT(A1),
what does rept translate 2?
Rept means repeat which in German is according to Google translate: Wiederholung
If you could upload an example workbook right to this forum, we could modify it right in the workbook. Then when you download it, it would revert back to German (Go Advanced>Manage Attachments)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
worksheet2.xlsxworksheet.xlsx
I need worksheet to have 3 repeating characters and worksheet 2 to have 2 repeating chars.. so its a totall of 5 chars
Okay, in Worksheet2, just simply
=A1&RIGHT(A1) (I assume by 2 repeating characters, there's the one that's already there and a new one)
In Worksheet
=A1& REPT(A1),2)
You can copy the new column back over the old with Paste Special>Values to remove the formulas.
Questions?
These are the formulae used on Tabelle2 to Tabelle4. Enter in A1 of each worksheet and fill down. I think that I may have given you more than you wanted but I am a little confused by the way you stated the problem.
Tabelle2
Formula:Please Login or Register to view this content.
Tabelle3
Formula:Please Login or Register to view this content.
Tabelle4
Formula:Please Login or Register to view this content.
I think i am all done, everything sloved. TYVM everyone for such fast help
Thank you 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. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks