• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Knute Snortum
  • Paul Clapham
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Frits Walraven
Bartenders:
  • Ganesh Patekar
  • Tim Holloway
  • salvin francis

Need some help in Excel  RSS feed

 
Ranch Hand
Posts: 159
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I want to create the following:
I have a column in excel named "names"

Names
-----
Mary White
Bob Smith

and I want this column to become as following:

Names
-----
Mary45 White45
Bob45 Smith45

Does anyone know a way to achieve this in Microsoft Excel?

Thank you,
 
Greenhorn
Posts: 6
Chrome Fedora Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't believe there is an easy way to do this in Excel, but this is something you could do in an advanced text editor, like Sublime or VSCode.

I would export the file as a CSV, and then use the multi-cursor feature in the text editor to get a cursor on each line. Then, you can easily add "45" to the end of each word. Then just re-import to Excel.
 
Saloon Keeper
Posts: 3255
128
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Depending on the exact requirements, what about a little VBA code?
 
Ioanna Katsanou
Ranch Hand
Posts: 159
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,


I figured it out
=SUBSTITUTE(A1&"45";" ";"45 ")

thanks !!
 
I knew I would regret that burrito. But this tiny ad has never caused regrets:
how do I do my own kindle-like thing - without amazon
https://coderanch.com/t/711421/engineering/kindle-amazon
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!