Related Posts

4 comments

Kanwaljit Singh Dhunna

Hi Bastien,

May the Family Live 1000 Years !

I am delighted to see that ASAP's fan list is growing at an electric speed :)

One Suggestion :

Column + Rows – Merge Column Data
There is an option to insert values between two columns. I wish there could be another Option to insert some value at the end as well as at the beginning of the merged column. That would help save a step if someone wishes to do so.

Regards
CA Kanwaljit Singh Dhunna

Bastien

Hello Kanwaljit,

Thank you for your feedback and compliment.

At this moment you can indeed only choose to insert a certain value between the column-data with the Merge column data (join cells)… tool. Not before and/or after.
//www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=61&utilities=58&lang=en_us
A request to insert something at the front and/or at the end has never been made before. Do you need to use that often?

For now you can use the following tool after you've merged the column-data, to quickly insert a certain value at the beginning and/or end of each cell in your selection:
ASAP Utilities » Fill » Insert before and/or after each cell in your selection…
//www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=79&utilities=104&lang=en_us

And by adding it to your favorites menu and/or assign your own shortcut key to itm you can quickly start it:
ASAP Utilities » Favorites & Shortcuts » Organize your favorite tools…
//www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=229&utilities=228&lang=en_us

Kind regards,
Bastien Mensink

Kanwaljit Singh Dhunna

Hi Bastien,

May the Family Live 1000 Years !

1st : Yes, I need to do that quite often.
2nd : I am using the above shortcuts to do that at present. The above suggestion would just help to reduce one or two steps to do that.
3rd : Is there any option to insert something after a number of characters ?

Regards
CA Kanwaljit Singh Dhunna

Bastien

Hello Kanwaljit,

Thank you for your feedback.

I've added your suggestion to the wishlist in case more peope ask for it.
At this moment there isn't a tool in ASAP Utilities to insert something after a number of characters yet. This would be a good addition. Noted too.

Kind regards,
Bastien Mensink