I don't understand.You wanted to split a string into columns using "-" as the
delimiter.What does that have to do with "one character, not three"?
how does that apply? Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all
I ended up replacing " - " with "*" and then used "*" as the deliminator
On Friday, November 6, 2015 at 10:04:57 AM UTC-5, drew...@gmail.com wrote:
>
> Hello,
>
> I would be very grateful if someone could provide a formula for dividing
> text to columns using " - " as a deliminator.
>
> Many Than
Excel 2007, but it only allows for one character not three
On Friday, November 6, 2015 at 11:23:11 AM UTC-5, Paul Schreiner wrote:
>
> What version of excel are you using?
>
> If it is Excel 2007 or later, there is a text-to-columns option in the
> "Data" tab.
>
> If you're looking for a VBA fun
Here's the approach I took:You need to make each entry "unique".so, I used
=COUNTIF(A2:$A$35,A2)
in column B to count the number of occurrences of the value in column A,but
only from the current position DOWN.That means that since 223.20 appears twice
in the list,the first time, the count is 2,b
Dear All,
Pls help in matching the data of two different ledgers to reconcile figures
from respective books and identify missing amounts since several amounts
would be same figures which i couldn't match in Vlookup.
awaiting your positive reply.
Thanks,
Regards.
--
Are you =EXP(E:RT) or =NOT(
What version of excel are you using?
If it is Excel 2007 or later, there is a text-to-columns option in the "Data"
tab.
If you're looking for a VBA function, you should be able to record a macro
while you utilize this icon.
If you're actually looking for an Excel FORMULA as you requested, you're
Hello,
I would be very grateful if someone could provide a formula for dividing
text to columns using " - " as a deliminator.
Many Thanks,
Andrew
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
htt
Thank you.
Yes, I think adding .Value should solve the problem.
Now VBA is referencing the value from that cell.
Adding .Value should allow it to take the value only and will not change as
the value in the cell changes.
Just like a paste special value.
I will test it at the lab next Mo
The problem is:You should use:
Option Explicit
at the beginning of each code module(you can make it automatic by selecting
Tools->Options and Select "Require Variable Declaration")
If you did that, you'd see that you are declaring Num_Sell as an integer.
but then you're defining DIM_Sell as a RANG
I DID post it, within the attachment, as well as describing the technique.
Each case is unique, the functions themselves don't do much without the
workbook to provide context.
But I can explain the technique in more detail:
In this case for example, he wanted to collect all "Activity codes" relate
Good afternoon everyone,
I have a table with a breakdown of sales per day
I made two column to know the week number of the date, and the month of the
date.
I add conditional formating on these 2 columns to highlight them in green
if it's the current week/month, everything fine.
Now, what I would
11 matches
Mail list logo
