If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Inserting a space into a text string
Here is my question:
I am trying to insert a space at a specific point in a text string. Please see example below. Text string = ROF13734357/2R4A The result I want is as follows: Text string = ROF13734357/2 R4A The problem is that I never know exactly what position the "R" will be in or if there will be more than one "R" in the text string. Bottom line is, I want to insert a space immediately BEFORE the LAST "R" in the text string. Any ideas? This one has had me stumped for quite some time. Thanks. Brian Anderson |
#2
|
|||
|
|||
Inserting a space into a text string
Hi Brian!
Try: =SUBSTITUTE(A1,"R"," R",LEN(A1)-LEN(SUBSTITUTE(A1,"R",""))) -- -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Brian Anderson" wrote in message ... Here is my question: I am trying to insert a space at a specific point in a text string. Please see example below. Text string = ROF13734357/2R4A The result I want is as follows: Text string = ROF13734357/2 R4A The problem is that I never know exactly what position the "R" will be in or if there will be more than one "R" in the text string. Bottom line is, I want to insert a space immediately BEFORE the LAST "R" in the text string. Any ideas? This one has had me stumped for quite some time. Thanks. Brian Anderson |
Thread Tools | |
Display Modes | |
|
|