Posted to microsoft.public.excel.programming

Andrew[_56_] Andrew[_56_] is offline

external usenet poster

Posts: 130

Odd behavior using CONCATENATE

Hello,
I have one spreadsheet where I am trying to use CONCATENATE to combine
some text and a number.
The cell T6 contains "AT COST X "
The cell S7 contains a number 1.18
The cell S8 contains =CONCATENATE(T6,S7)

I get a #VALUE error on this, and I can't figure out why.

Any ideas?

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
Odd behavior	Otto Moehrbach	Excel Programming	4	October 23rd 07 08:03 PM
Alt+E Behavior	Sam Chambers	Excel Discussion (Misc queries)	3	June 8th 07 04:23 PM
Odd Tab behavior	Jim Thomlinson	Excel Programming	1	July 11th 06 05:24 AM
I know how to concatenate ,can one de-concatenate to split date?	QUICK BOOKS PROBLEM-	New Users to Excel	1	July 26th 05 05:07 PM
odd behavior	marwan hefnawy	Excel Programming	0	September 21st 04 05:15 AM

All times are GMT +1. The time now is 01:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us