Posted to microsoft.public.excel.misc

scubadiver scubadiver is offline

external usenet poster

Posts: 55

Concatenate question

As an example, in A2 I have the number 56 and I have other numbers below it
in a column. I would use the following

=concatenate("'",A2,"',")

to create

'56',

but if I copy the formula down the column, the cell remain as

'56',

rather than changing to what is in the reference cell. Is this because the
reference cells are formatted wrongly?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenate Question	CJN	Excel Worksheet Functions	4	April 14th 08 05:04 PM
Concatenate question	DianaL	Excel Worksheet Functions	4	March 27th 08 02:26 PM
CONCATENATE Question	Anthony	Excel Discussion (Misc queries)	4	March 16th 08 11:31 PM
Concatenate Question	Learningfast	Excel Worksheet Functions	4	January 16th 08 06:14 AM
Concatenate question	nick	Excel Worksheet Functions	3	July 27th 06 11:40 PM

All times are GMT +1. The time now is 03:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us