Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Could one of the resident macro experts kindly help me to do this
please. There is text in column D of a worksheet. I want to remove anything that is in brackets, including the brackets. So this: A B C D -- -- --------------- ------------------------------------------- 1 P Andrews Sisters Boogie Woogie (1941 version) 2 Q Artie Shaw (1941) Concerto For Clarinet (Parts 1 & 2) 3 R Artie Shaw Dancing In The Dark 4 S Artie Shaw Frenesi becomes this: 1 P Andrews Sisters Boogie Woogie 2 Q Artie Shaw Concerto For Clarinet 3 R Artie Shaw Dancing In The Dark 4 S Artie Shaw Frenesi Thanks. -- Terry, West Sussex, UK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro that finds text and keeps only part of it | Excel Discussion (Misc queries) | |||
In Excel need macro to tell if Text Box is Blank or has Text | Excel Discussion (Misc queries) | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
Remove Numbers from text | Excel Worksheet Functions | |||
remove spaces in text in excel | Excel Discussion (Misc queries) |