| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Carriage Return By Replace() function
I have a data like:
A1: ABCDEFG, HIJK, LMNOPQRSTUV, WXYZ A2: ABC, DEFG, HIJK, LMNOPQRSTUV, WXYZ A3: ABCDEFGHIJK, LMNOPQRSTUV, WXYZ Shall appreciate a formula using Replace and Char(10) function in cells B1, B2, B3 or ANY other way so as to present the data as: B1: ABCDEFG, HIJK, LMNOPQRSTUV, WXYZ B2: ABC, DEFG, HIJK, LMNOPQRSTUV, WXYZ B3: ABCDEFGHIJK, LMNOPQRSTUV, WXYZ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find replace text or symbol with carriage return | New Users to Excel | |||
| Find and replace a space with carriage return in excel | Excel Discussion (Misc queries) | |||
| How to remove or replace a carriage return character in a cell? | Excel Discussion (Misc queries) | |||
| Search and replace with Carriage return | Excel Discussion (Misc queries) | |||
| Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions | |||
Threaded Mode
