ExcelBanter - looking for short cut

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - looking for short cut (https://www.excelbanter.com/excel-worksheet-functions/214168-looking-short-cut.html)

Dylan @ UAFC[_2_]

looking for short cut

Can't get this to work right.
got about 300000 rows

just need to considate
=a1&"_"&b1 (need to have the _)
of course when I crtl + shift + enter
it copies the same form all the way down

shortcut advise plese

Glenn

looking for short cut

Dylan @ UAFC wrote:
Can't get this to work right.
got about 300000 rows

just need to considate
=a1&"_"&b1 (need to have the _)
of course when I crtl + shift + enter
it copies the same form all the way down

shortcut advise plese

Let go of the shift.

Dylan @ UAFC[_2_]

looking for short cut

Perfect.
New there was an easy way

"Glenn" wrote:

Dylan @ UAFC wrote:
Can't get this to work right.
got about 300000 rows

just need to considate
=a1&"_"&b1 (need to have the _)
of course when I crtl + shift + enter
it copies the same form all the way down

shortcut advise plese

Let go of the shift.

All times are GMT +1. The time now is 06:15 PM.