VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,284
- Office Version
- 365
- Platform
- Windows
Hi All,
Good Afternoon,
I have one query regarding, How can only selelcted content make Upper case.
Say Eg.-
Original Data................answer to be required
abc to pqr...................ABC to PQR
london from newyork.....LONDON from NEWYORK
pqr pqr.......................PQR PQR
qwe Na2Co3 hi.............QWE Na2Co3 HI
H2So4 hello.................H2So4 HELLO
how can this possible?
we can read the content. We can even do the upper case the letters if v know exact markup atleast.
But this "to" "from" "Na2Co3" "NaOH" H2So4" not be sure, at which place this will display.
Actually dis is the advantage that,
if cells.conetent = "to" "from" "Na2Co3" "NaOH" H2So4" this then
leave this tag and make other in CAPITAL.
But How? is the big question mark?
Good Afternoon,
I have one query regarding, How can only selelcted content make Upper case.
Say Eg.-
Original Data................answer to be required
abc to pqr...................ABC to PQR
london from newyork.....LONDON from NEWYORK
pqr pqr.......................PQR PQR
qwe Na2Co3 hi.............QWE Na2Co3 HI
H2So4 hello.................H2So4 HELLO
how can this possible?
we can read the content. We can even do the upper case the letters if v know exact markup atleast.
But this "to" "from" "Na2Co3" "NaOH" H2So4" not be sure, at which place this will display.
Actually dis is the advantage that,
if cells.conetent = "to" "from" "Na2Co3" "NaOH" H2So4" this then
leave this tag and make other in CAPITAL.
But How? is the big question mark?
