| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Strip Values From Cells To Create New Cell Value
Hello everyone. I am a beginner and need some help from the forum!
here is the problem I have: My excel sheet has multiple fields with data in it.Ex: Type Use ____ ___ Rock Build house Sand Play on it Gravel Drive on it I want to take the first letter of the Type value (R from Rock) and Concatenate it with the first letter of Use column (Build from Build House) and concatenate it with an user input which is constant for all rows. I need this value RBuildxxx on the same row as Rock. I would also like to know how to select the data range (for the # of rows I need) and how to select the target row. thanks a lot for the help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Strip Values From Cells To Create New Cell Value
I think you meant the first word of column B. Presuming a space should be used as the
delimiter (between "Build" and "House") try this =LEFT(A2,1) & LEFT(B2,SEARCH(" ",B2,1)-1) & "xxx" If the user input is in a cell, like C2, then use: =LEFT(A2,1) & LEFT(B2,SEARCH(" ",B2,1)-1) & C2 -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- wrote in message oups.com... Hello everyone. I am a beginner and need some help from the forum! here is the problem I have: My excel sheet has multiple fields with data in it.Ex: Type Use ____ ___ Rock Build house Sand Play on it Gravel Drive on it I want to take the first letter of the Type value (R from Rock) and Concatenate it with the first letter of Use column (Build from Build House) and concatenate it with an user input which is constant for all rows. I need this value RBuildxxx on the same row as Rock. I would also like to know how to select the data range (for the # of rows I need) and how to select the target row. thanks a lot for the help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Strip Values From Cells To Create New Cell Value
On 27 Feb, 20:06, "Earl Kiosterud" wrote:
I think you meant the first word of column B. Presuming a space should be used as the delimiter (between "Build" and "House") try this =LEFT(A2,1) & LEFT(B2,SEARCH(" ",B2,1)-1) & "xxx" If the user input is in a cell, like C2, then use: =LEFT(A2,1) & LEFT(B2,SEARCH(" ",B2,1)-1) & C2 -- Earl Kiosterudwww.smokeylake.com wrote in message oups.com... Hello everyone. I am a beginner and need some help from the forum! here is the problem I have: My excel sheet has multiple fields with data in it.Ex: Type Use ____ ___ Rock Build house Sand Play on it Gravel Drive on it I want to take the first letter of the Type value (R from Rock) and Concatenate it with the first letter of Use column (Build from Build House) and concatenate it with an user input which is constant for all rows. I need this value RBuildxxx on the same row as Rock. I would also like to know how to select the data range (for the # of rows I need) and how to select the target row. thanks a lot for the help! Thanks! Should have mentioned that I need to do it from a macro. There are going to be multiple rows that I need to modify, and I would like to use a macro that will do it for the selected range of rows. thanks again! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match values and create a list in one cell | Excel Discussion (Misc queries) | |||
| Formula to strip figures from cells text strings | Excel Discussion (Misc queries) | |||
| Strip leading spaces from cell | Excel Worksheet Functions | |||
| HOW DO I CREATE A MACRO TO STRIP OUT ROWS? | Excel Discussion (Misc queries) | |||
| How can I strip a new line /nl in a cell in Excel globally | Excel Worksheet Functions | |||
Linear Mode
