| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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","") |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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","") |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to remove text in specific place | Excel Worksheet Functions | |||
| remove duplicate rows from specific data in a column; excel 2007 | Excel Worksheet Functions | |||
| Remove specific Pivotcache fields | Excel Discussion (Misc queries) | |||
| Remove Specific Text - HELP! | Excel Worksheet Functions | |||
| How do I remove all text in a cell after a specific character? | Excel Worksheet Functions | |||
Linear Mode
