Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search and replace with Carriage return
Hi there,
How do I search and replace a range with the following change - commas (,) changed to carriage return (achieved by pressing alt+enter when typing in a cell) Regards Andi |
#2
|
|||
|
|||
Select the range, press Ctrl+H, and in "find what" put a comma, and in
"replace with", hold down the ALT key and type 0010 on your numeric keypad. Replace All. HTH Jason Atlanta, GA "Andibevan" wrote: Hi there, How do I search and replace a range with the following change - commas (,) changed to carriage return (achieved by pressing alt+enter when typing in a cell) Regards Andi |
#3
|
|||
|
|||
Thanks Jason - hadn't thought of doing it like that.
"Jason Morin" wrote in message ... Select the range, press Ctrl+H, and in "find what" put a comma, and in "replace with", hold down the ALT key and type 0010 on your numeric keypad. Replace All. HTH Jason Atlanta, GA "Andibevan" wrote: Hi there, How do I search and replace a range with the following change - commas (,) changed to carriage return (achieved by pressing alt+enter when typing in a cell) Regards Andi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search and Replace | Excel Discussion (Misc queries) | |||
Search and Replace Question | New Users to Excel | |||
GLOBAL search and replace | New Users to Excel | |||
Excel - Formula Query: Search for and Return Value | Excel Worksheet Functions | |||
search & replace | Excel Worksheet Functions |