hello everyone,,please helpp meee,,i have alott of data in my cells written like this sara,thomas ....i want to insert a line break so it appears like Sara, thomas
how do i do this for multiple cells??? data is in row 2 to row 439 in column 4.
Without going into code, you can search and replace; first select the cells you want to effect a change in (you should select more than one cell as if you don't, the whole sheet is searched and replaced!), then press Ctrl + H to bring up the dialogue box, then in the find what field enter a comma, then in the Replace with field you need to enter a new line character; this is where you need to be careful. Essentially, you need to enter that character with the numeric keypad while holding down the ALT key, type in: zero one zero: 010
then let go of the alt key. You won't see much in the field, it doesn't matter, click OK and you're done.
Has your keyboard not got a numeric keypad? Laptops/notebooks often don't seem to have one, but they normally do, usually reachable by a NumLock key, when you then need to look for the numbers on the keyboard - on mine the M has a 0 and the J has a 1