Win a copy of Spring in Action (5th edition) this week in the Spring forum!
  • 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
  • Bear Bibeault
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Ganesh Patekar
  • Frits Walraven
  • Tim Moores
  • Ron McLeod
  • Carey Brown
Bartenders:
  • Stephan van Hulst
  • salvin francis
  • Tim Holloway

Need some help in Excel  RSS feed

 
Ranch Hand
Posts: 158
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.
 
Master Rancher
Posts: 3001
105
  • 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: 158
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,


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

thanks !!
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!