Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 110
Default concatenate

I want to conatenate 2 cells. In cell A1 I have a Vlookup and cell A2 I have
a number.

In cell a3 when I put =concatenate(a1,a2) I'm getting a #ref!. I'm sure
it's because of the lookup, but I really don't want to change my lookup to a
value.

Is there anyway to get around it?

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Nadeem Excel Worksheet Functions 3 September 22nd 06 02:53 AM
Need to Concatenate hamster Excel Discussion (Misc queries) 9 November 11th 05 09:18 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
concatenate jeanette.rimmer Excel Worksheet Functions 3 July 25th 05 11:41 AM
Un - Concatenate? JudithJubilee Excel Worksheet Functions 2 July 11th 05 09:57 AM


All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"