| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying text to new cell
I need to copy varying lenght text strings to new cells but I need to drop
the last 6 right most characters of each string. Any ideas? I am working in Excel 2003 SP3 Thanks in advance for any help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying text to new cell
if your text is in A1 and you want tyour result in B1, put this in Cell B1
=LEFT(A1,LEN(A1)-6) "drob2528" wrote: I need to copy varying lenght text strings to new cells but I need to drop the last 6 right most characters of each string. Any ideas? I am working in Excel 2003 SP3 Thanks in advance for any help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying text to new cell
For data in column A, in B1 enter:
=LEFT(A1,LEN(A1)-6) -- Gary''s Student - gsnu200777 "drob2528" wrote: I need to copy varying lenght text strings to new cells but I need to drop the last 6 right most characters of each string. Any ideas? I am working in Excel 2003 SP3 Thanks in advance for any help |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying text to new cell
Thanks Dennis, that worked. I knew about LEFT, forgot abot the LEN command.
"Dennis" wrote: if your text is in A1 and you want tyour result in B1, put this in Cell B1 =LEFT(A1,LEN(A1)-6) "drob2528" wrote: I need to copy varying lenght text strings to new cells but I need to drop the last 6 right most characters of each string. Any ideas? I am working in Excel 2003 SP3 Thanks in advance for any help |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying text to new cell
Thanks "Gary's" Student, that worked. Knew about LEFT, forgot about the LEN
command. "Gary''s Student" wrote: For data in column A, in B1 enter: =LEFT(A1,LEN(A1)-6) -- Gary''s Student - gsnu200777 "drob2528" wrote: I need to copy varying lenght text strings to new cells but I need to drop the last 6 right most characters of each string. Any ideas? I am working in Excel 2003 SP3 Thanks in advance for any help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Hyperlink to a Cell with Text | Excel Discussion (Misc queries) | |||
| Copying text to another cell | Excel Discussion (Misc queries) | |||
| Copying text from a cell | Excel Worksheet Functions | |||
| copying a cell and changing the formating from number to text | Excel Discussion (Misc queries) | |||
| Copying Text to another cell/worksheet | Excel Worksheet Functions | |||
Linear Mode
