| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula for cell
I have many cells with descriptive text, does anyone know of a formula
where I can take for instance a cell with 500 characters and take only the first 30 and paste it in to a new cell. I have used a formula thanks to Gary =left(a1,len(a1)/2 which has worked for other uses I have--now I need to extract only the first 30 characters of a description and I have thousands of cells in my description column..Please Help |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula for cell
|
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula for cell
The formula
=left(a1,30) will take the 30 left most characters from cell A1. Regards. Bill Ridgeway Computer Solutions wrote in message oups.com... I have many cells with descriptive text, does anyone know of a formula where I can take for instance a cell with 500 characters and take only the first 30 and paste it in to a new cell. I have used a formula thanks to Gary =left(a1,len(a1)/2 which has worked for other uses I have--now I need to extract only the first 30 characters of a description and I have thousands of cells in my description column..Please Help |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula for cell
Thank You Bill, thats great!
Bill Ridgeway wrote: The formula =left(a1,30) will take the 30 left most characters from cell A1. Regards. Bill Ridgeway Computer Solutions wrote in message oups.com... I have many cells with descriptive text, does anyone know of a formula where I can take for instance a cell with 500 characters and take only the first 30 and paste it in to a new cell. I have used a formula thanks to Gary =left(a1,len(a1)/2 which has worked for other uses I have--now I need to extract only the first 30 characters of a description and I have thousands of cells in my description column..Please Help |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula for cell
Excel HELP would have worked
LEFT Worksheet Function try it now, as things are usually easier to find when you know the answer, and it would help you find answers the next time. wrote Thank You Bill, thats great! Bill Ridgeway wrote: The formula =left(a1,30) will take the 30 left most characters from cell A1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
