Hi,
Below starts in Cell A1, formulas are below. Hope it helps.
20500:0020500 00
=LEFT(A1,FIND(":",A1)-1)=RIGHT(A1,2)
18456:5618456 56
=LEFT(A3,FIND(":",A3)-1)=RIGHT(A3,2)
20434 2043:4
=IF(C1 wrote:
> I am trying to subt
Hameet,
Try the concatenate function
=CONCATENATE("I have "&B1&" hands and "&C1&" Eyes")
Notice the spaces for the text inside the quotation marks...you need
those spaces to format your sentence properly.
On Jun 15, 6:37 pm, Harmeet Singh wrote:
> this should help. see attached file
>
> Warm
hi friends,
i have an unique and different problem..., i want to updates my
excel file automatically as soon i'll update my autocad file.
i'll explain in detail,
i have an autocad drawing which r having so many data like figure,
text etc.., for better understanding i take the example of a rect
hi friends,
i have an unique and different problem..., i want to updates my
excel file automatically as soon i'll update my autocad file.
i'll explain in detail,
i have an autocad drawing which r having so many data like figure,
text etc.., for better understanding i take the example of a rect
Hi Alvin,
I uploaded an example/explanation of what I'm trying to do. The file
is called EXCEL_SPREADSHEET.xlsx in the file section. Not sure how to
upload it to this message..
Thanks,
Kristin
On Jun 15, 9:35 pm, fongie wrote:
> Hi Kristin,
>
> Have you got an email I can send a file sample
Hi Ragina,
I tried the Vlookup as you have mentioned in your query, but it is working
for me.
If you could provide the sample data then we can help you.
Regards,
Swapnil.
On Wed, Jun 16, 2010 at 3:17 PM, ExcelVBA wrote:
> I am trying to use function Vlookup, but the cell value I am refering
>
Hi Regina,
Please attach a sample worksheet with your problem.
On Wed, Jun 16, 2010 at 3:17 PM, ExcelVBA wrote:
> I am trying to use function Vlookup, but the cell value I am refering
> contains a function and the result I am getting is #N/A , is anyone
> who knows how I can solve this proble
the fact that the cell you're referring to is a function is irrelevant.
it should still work.
Let's say that you have:
A B
1 Jan
2 Feb
3 Mar
4 Apr
5 May
6 Jun
7 Jul
8 Aug
9 Sep
10 Oct
11 Nov
12 Dec
and you want to find the month name of the current month
(I know, there's other ways of d
I am trying to use function Vlookup, but the cell value I am refering
contains a function and the result I am getting is #N/A , is anyone
who knows how I can solve this problem.
Regina
--
--
Some important links fo