Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I fix a field length?
I need to 'fix' a field length to 15 characters (last name field) in order to
export to a comma deliminated ASCII text file to then be imported into another database program. I am NOT familiar with macros and visual basic code, so if a reply involves writing a macro to get the result I need, please be as specific as possible. Thank you very much in advance. -K |
#2
|
|||
|
|||
Karina,
Use another sheet, filled with formulas like: =LEFT(Sheet1!A1& REPT(" ",15),15) and copy down and across as far as you need. Then copy and pastespecial values, then do your export. HTH, Bernie MS Excel MVP "Karina" wrote in message ... I need to 'fix' a field length to 15 characters (last name field) in order to export to a comma deliminated ASCII text file to then be imported into another database program. I am NOT familiar with macros and visual basic code, so if a reply involves writing a macro to get the result I need, please be as specific as possible. Thank you very much in advance. -K |
#3
|
|||
|
|||
Fill the whole sheet with that formula?
It is only one colum I need to be fixed to 15 characters in length. All other columns in the spreadsheet can be varied lengths. "Bernie Deitrick" wrote: Karina, Use another sheet, filled with formulas like: =LEFT(Sheet1!A1& REPT(" ",15),15) and copy down and across as far as you need. Then copy and pastespecial values, then do your export. HTH, Bernie MS Excel MVP "Karina" wrote in message ... I need to 'fix' a field length to 15 characters (last name field) in order to export to a comma deliminated ASCII text file to then be imported into another database program. I am NOT familiar with macros and visual basic code, so if a reply involves writing a macro to get the result I need, please be as specific as possible. Thank you very much in advance. -K |
#4
|
|||
|
|||
Karina,
Fill one column on your original sheet with that formula, and then copy the formulas and pastespecial values over the original data, and delete the formula column. Then do your export. HTH, Bernie MS Excel MVP "Karina" wrote in message ... Fill the whole sheet with that formula? It is only one colum I need to be fixed to 15 characters in length. All other columns in the spreadsheet can be varied lengths. "Bernie Deitrick" wrote: Karina, Use another sheet, filled with formulas like: =LEFT(Sheet1!A1& REPT(" ",15),15) and copy down and across as far as you need. Then copy and pastespecial values, then do your export. HTH, Bernie MS Excel MVP "Karina" wrote in message ... I need to 'fix' a field length to 15 characters (last name field) in order to export to a comma deliminated ASCII text file to then be imported into another database program. I am NOT familiar with macros and visual basic code, so if a reply involves writing a macro to get the result I need, please be as specific as possible. Thank you very much in advance. -K |
#5
|
|||
|
|||
Thank you Mr.Deitrick .... you are a genius and my new best friend!
That worked marvelously. Now ... I shall look back at other questions to see how to combine the last name and first name into one cell ..... "Smith Joe" (in addition to that padded cell formula). Thank you so much! ... Karina (not the Karina from previous posts in this discussion group) "Bernie Deitrick" wrote: Karina, Fill one column on your original sheet with that formula, and then copy the formulas and pastespecial values over the original data, and delete the formula column. Then do your export. HTH, Bernie MS Excel MVP "Karina" wrote in message ... Fill the whole sheet with that formula? It is only one colum I need to be fixed to 15 characters in length. All other columns in the spreadsheet can be varied lengths. "Bernie Deitrick" wrote: Karina, Use another sheet, filled with formulas like: =LEFT(Sheet1!A1& REPT(" ",15),15) and copy down and across as far as you need. Then copy and pastespecial values, then do your export. HTH, Bernie MS Excel MVP "Karina" wrote in message ... I need to 'fix' a field length to 15 characters (last name field) in order to export to a comma deliminated ASCII text file to then be imported into another database program. I am NOT familiar with macros and visual basic code, so if a reply involves writing a macro to get the result I need, please be as specific as possible. Thank you very much in advance. -K |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to CONCATENATE two dates field together | Excel Worksheet Functions | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) |