Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have a column in an excel sheet (max 65000 rows) which contains text. I
want to strip off the first word of the text string and place this into a different column leaving the rest(minus this one word) in the original column cell. in toal i have 85000 records and doing this by hand will take for ever. Once this is done I will transfer all records to an access database. can some one please give me a guide on how to go about doing this |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text string and sum | Excel Worksheet Functions | |||
Remove last character of text string | Excel Worksheet Functions | |||
dynamic cell reference within a text string | Excel Worksheet Functions | |||
Extracting from a text string | Excel Worksheet Functions | |||
Formating a text string? | Excel Discussion (Misc queries) |