Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi guys
I am writing an Access d/b that uses an Excel spreadsheet as it's data source. The spreadsheet contains about 24,000 rows. I have noticed that in some of the columns numbers are formatted with an apostrophe. I would like to create a routine that searches through specified columns and adds an apostrophe to the start of each entry, but I am not that familiar with Excel. Does anyone know where I might find such a routine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) | |||
Delete apostrophe | Excel Discussion (Misc queries) |