• 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
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • paul wheaton
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Tim Holloway
  • Carey Brown
  • salvin francis

Need some help in Excel

 
Ranch Hand
Posts: 159
1
Oracle Java
  • 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: 3451
149
  • 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
Oracle Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,


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

thanks !!
 
I would challenge you to a battle of wits, but I see you are unarmed - shakespear. Unarmed tiny ad:
professionally read, modify and write PDF files from Java
https://products.aspose.com/pdf/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!