topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Thursday March 28, 2024, 9:54 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Find and Replace Preset  (Read 3579 times)

krcc18a

  • Supporting Member
  • Joined in 2013
  • **
  • default avatar
  • Posts: 7
    • View Profile
    • Donate to Member
Find and Replace Preset
« on: October 16, 2013, 06:07 PM »
In Excel:

I need to copy part of a column (several cells), and then paste the contents of those cells into one single other cell with the ALT-ENTER character between the value taken from each cell.

So if I had
A
B
C
in three cells, I need to paste A ALT-ENTER B ALT-ENTER C into a single cell.

Am I replacing a {TAB} character? And what would the ALT-ENTER character be?

Thanks,
Marty

dcwul62

  • Supporting Member
  • Joined in 2013
  • **
  • default avatar
  • Posts: 336
    • View Profile
    • Donate to Member
Re: Find and Replace Preset
« Reply #1 on: October 20, 2013, 12:17 AM »
Hello,
up front, I am not an Excel expert...

am not sure if this can be solved within the current Clipboard Help and Spell.
under "Modfy Format/Case" one can add \n to lines but not to words.


Anyway, a suggestion only...

I would download a named ASAP Utilities at: http://www.asap-utilities.com/
basically it is free
".. you are hereby licensed to use the SOFTWARE without charge in a non-commercial organization or for home-use.
To avoid the use of obsolete SOFTWARE each unregistered version will display an update notice 6 months and expires 9 months after its release
."

It installs a plug-in with a lot of handy features.

Within ASAP this is really a piece of cake:
Click ASAP tab, then select Columns & Rows  and then  Merge row data, separated cells by a line break

See below.

Maybe this is what you are looking for?

Good luck!
=
Excel-MergeCellsWithLinebreaks-20102013 063922.pngFind and Replace Preset
=









krcc18a

  • Supporting Member
  • Joined in 2013
  • **
  • default avatar
  • Posts: 7
    • View Profile
    • Donate to Member
Re: Find and Replace Preset
« Reply #2 on: October 23, 2013, 07:22 PM »
Many thanks, but I am still inclined to think that there should be a way to do this within CHS.

I thought perhaps SENDKEYS and trim line ends.

I tried a custom script tool to include a char(10) which ran after trimming line ends.

Marty