| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include part of a cell in text (string?) in another cell?
I have a spreadsheet in which A:1 contains First and Second Names as a
single entry, e.g. 'Fred Smith'. I want to be able to include only the First Name in statements in other fields, e.g. 'Fred can .' I have considered splitting the name across two fields, but this would introduce other complications. How can I refer to A:1 such that only the first name, which is of variable length, will be picked up, i.e. everything up to, and possibly including' the space? I know I can use '=A:1& 'can.'' which will come out as 'Fred Smith can.', but how do I make it read 'Fred can.'? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I include part of a cell in text (string?) in another cell?
I have a spreadsheet in which A:1 contains First and Second Names as a
single entry, e.g. 'Fred Smith'. I want to be able to include only the First Name in statements in other fields, e.g. 'Fred can .' I have considered splitting the name across two fields, but this would introduce other complications. How can I refer to A:1 such that only the first name, which is of variable length, will be picked up, i.e. everything up to, and possibly including' the space? I know I can use '=A:1& 'can.'' which will come out as 'Fred Smith can.', but how do I make it read 'Fred can.'? This formula... =LEFT(A6,FIND(" ",A6)-1) will pick up the text up to, but not including, the space following it. If you want to keep the space, remove the -1. Rick |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I include part of a cell in text (string?) in another cell?
Thanks Rick, works a treat.
"Rick Rothstein (MVP - VB)" wrote in message ... I have a spreadsheet in which A:1 contains First and Second Names as a single entry, e.g. 'Fred Smith'. I want to be able to include only the First Name in statements in other fields, e.g. 'Fred can .' I have considered splitting the name across two fields, but this would introduce other complications. How can I refer to A:1 such that only the first name, which is of variable length, will be picked up, i.e. everything up to, and possibly including' the space? I know I can use '=A:1& 'can.'' which will come out as 'Fred Smith can.', but how do I make it read 'Fred can.'? This formula... =LEFT(A6,FIND(" ",A6)-1) will pick up the text up to, but not including, the space following it. If you want to keep the space, remove the -1. Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Text from one cell as part of a cell reference in another | Excel Discussion (Misc queries) | |||
| removing part of text string to another cell | Excel Discussion (Misc queries) | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| How do I delete part of a text string in every cell it appears in | Excel Discussion (Misc queries) | |||
| select part of a cell value string | Excel Discussion (Misc queries) | |||
Hybrid Mode
