Finding (RETURN) in a String within a cell

  • Thread starter Thread starter Michael Kintner
  • Start date Start date
M

Michael Kintner

I have a cell with several (RETURNS) in the cell. How can I use the FIND
function to find the position of the RETURN?

I do not know how I can enter the string value of RETURN in this function or
should I be using something else.

ie. Chr(13)???

Thank you in advance,
Mike
 
Ok, this semi-works, the ALT with character just beeps.

So, how can I using the menu REPLACE enter a Character (RETURN) the CHAR(10)
does nor work.
 
In Edit|replace?

If you want to replace the char(10), you can use:
alt-0010
(use the number keypad)
or just
ctrl-j
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find value within a text string 6
Split data in field on character return 0
String 2
Remove certain characters from a text string 6
Possible to select a string in a locked cell? 1
Building closed workbook file path within an Index Function 6
search text for substring and change text colour of substring 5
Searching a table of data using an array and returning the array's header?!? 4

Back
Top