G
Guest
060616 2 data types (same col/dif times), do: custom? parse? 2col?
Hi, have 2 different data types comming up: (thanks)
12:18pm - <b>69.09</b> (during business hours: Preferred Number)
69.09 (else avail. anytime, note: varying size number)
since receive mixed data, would hope MS could make a "Custom Format",
that would allow exclusion of trailing characters... what-ever needed to
get 69.09
prob1 / else: (not having an automated sheet, "yet")
where I download data, copy-paste, I have other required columns of data
(before / after) this field / column.
Q1: what is the easiest way to get what I need?
- can I custom format what I need (for view), I believe I can RIGHT/LEFT
LEN out what I need for formula's
- WHAT REALLY NEED, is for Custom Format (for view) to allow exlusion of
"right-most" characters: </b>
then:
Q2: then probably have a worker column that pulls the number out;
This version is not complete: How do I exlude the items from the left (as
it may be of varying lenght), so far have:
=IF(RIGHT(CJ9,1)=">",LEFT(CJ9,LEN(CJ9)-4),CJ9)
which leaves: 12:18pm - <b>69.09
note: price can be of varying length as well, e.g.: 0.63, or 1111.63
Hi, have 2 different data types comming up: (thanks)
12:18pm - <b>69.09</b> (during business hours: Preferred Number)
69.09 (else avail. anytime, note: varying size number)
since receive mixed data, would hope MS could make a "Custom Format",
that would allow exclusion of trailing characters... what-ever needed to
get 69.09
prob1 / else: (not having an automated sheet, "yet")
where I download data, copy-paste, I have other required columns of data
(before / after) this field / column.
Q1: what is the easiest way to get what I need?
- can I custom format what I need (for view), I believe I can RIGHT/LEFT
LEN out what I need for formula's
- WHAT REALLY NEED, is for Custom Format (for view) to allow exlusion of
"right-most" characters: </b>
then:
Q2: then probably have a worker column that pulls the number out;
This version is not complete: How do I exlude the items from the left (as
it may be of varying lenght), so far have:
=IF(RIGHT(CJ9,1)=">",LEFT(CJ9,LEN(CJ9)-4),CJ9)
which leaves: 12:18pm - <b>69.09
note: price can be of varying length as well, e.g.: 0.63, or 1111.63