REMOVE SPECIFIC DATA
 

i am importing this data from web and i want remove <BR always so please
help me in macro or some formulas, thanks in advance.

AT/AC/PS/PW/PM/LS/CS/RS<BR/CL/AR/ABS/SRS/5-STR/2DR
AT/AC/PS/PW/PM/LS/CS<BR/CL/AR/ABS/2-SRS/5-STR/5DR
AT/AC/PS/PW/PM/RS/WC<BR/1O/ABS/2-SRS/4-STR/2DR
AT/AC/PS/PW/PM/CL<BR/WC/ABS/2-SRS/5-STR/4DR

REMOVE SPECIFIC DATA
 

Tufail wrote:
i am importing this data from web and i want remove <BR always so
please help me in macro or some formulas, thanks in advance.

AT/AC/PS/PW/PM/LS/CS/RS<BR/CL/AR/ABS/SRS/5-STR/2DR
AT/AC/PS/PW/PM/LS/CS<BR/CL/AR/ABS/2-SRS/5-STR/5DR
AT/AC/PS/PW/PM/RS/WC<BR/1O/ABS/2-SRS/4-STR/2DR
AT/AC/PS/PW/PM/CL<BR/WC/ABS/2-SRS/5-STR/4DR

=SUBSTITUTE(A1,"<BR","")

REMOVE SPECIFIC DATA
 

thank you very much for very quick reply.

"Paul Lautman" wrote:

Tufail wrote:
i am importing this data from web and i want remove <BR always so
please help me in macro or some formulas, thanks in advance.

AT/AC/PS/PW/PM/LS/CS/RS<BR/CL/AR/ABS/SRS/5-STR/2DR
AT/AC/PS/PW/PM/LS/CS<BR/CL/AR/ABS/2-SRS/5-STR/5DR
AT/AC/PS/PW/PM/RS/WC<BR/1O/ABS/2-SRS/4-STR/2DR
AT/AC/PS/PW/PM/CL<BR/WC/ABS/2-SRS/5-STR/4DR

=SUBSTITUTE(A1,"<BR","")

REMOVE SPECIFIC DATA
 

One mo
select the range
edit|replace
what: <BR
with: (leave blank)
replace all



Tufail wrote:

i am importing this data from web and i want remove <BR always so please
help me in macro or some formulas, thanks in advance.

AT/AC/PS/PW/PM/LS/CS/RS<BR/CL/AR/ABS/SRS/5-STR/2DR
AT/AC/PS/PW/PM/LS/CS<BR/CL/AR/ABS/2-SRS/5-STR/5DR
AT/AC/PS/PW/PM/RS/WC<BR/1O/ABS/2-SRS/4-STR/2DR
AT/AC/PS/PW/PM/CL<BR/WC/ABS/2-SRS/5-STR/4DR

--

Dave Peterson