Re: Insert space 10 chars from end of row within indiv cells containing many rows
Hi Jaffey,
Keeping all the rows in the same cell can make your life more complicated ...
Should you split in individual rows ... you could test following formula :
=LEFT(A1,LEN(A1)-12)&" Ph: "&RIGHT(A1,12)
HTH
Re: Search Sheet for Text in range, delete rows not containing the text
Hi Anne,
Why don't you attach your workbook ...in order to get a precise answer ... (much better than general comments on the feasibility...)
Re: Add specific text to text box, based on dropdown list choice
Hello Anne,
The beauty with Excel ... is that everything is possible ...
For a precise answer ... you will need to better specify your constraints ...
Re: I need some help please thanks in advance
Hi,
See attached test file ... using Chip's formula
HTH
Re: I need some help please thanks in advance
Hi,
There are many different solutions ... e.g. with latitude and longitude
Take a look at Chip's solutions : http://www.cpearson.com/excel/LatLong.aspx
HTH
Re: Sheet Numbering
Hi,
You could take a look at a free add-in called Excel Explosion, which does it all for you ...
http://www.datapigtechnologies.com/freeware.htm
HTH
Carim
Re: Searching For Duplicates
Hi,
Something along these lines ...
=IF(COUNTIF(ListA!$A$2:$A$20,A2)>0,A2,"")HTH
Carim
Re: Quotations And Similar Characters In Strings
Hi,
Below is a tested code which works fine ...
Sub Testsit()
Dim tempString As String
tempString = "\" & Chr(96) & """www.ozgrid.com""" & "\" & Chr(96)
Range("A1").Value = tempString
End SubRe: Quotations And Similar Characters In Strings
Hi,
May be you could try concatenation with char(96) ...
HTH
Carim
Re: Repeat Values Into A Column
Stephen,
Thanks a LOT ... !!!
It is exactly what I was looking for ...
Cheers
Carim
Re: Repeat Values Into A Column
Thanks a lot Mac for the VBA solution which is working fine ...
But, for some distribution reason, I am looking for a Formula to replicate thr VBA code ...
Re: Repeat Values Into A Column
Thanks a lot for the VBA solution ...
but I am after a spreadsheet Formula ...
Hi,
I am looking for a formula to repeat a given set of values, a certain number of times ...
See attached for visual explanation ...
TIA