Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert a value to a text incl apostrophe within the cell
Dear experts,
I need a workaround BW reporting and the use of pivot tables in Excel. BW downloads e.g. material numbers incl an apostrophe e.g. '112233. However, this apostrophe is only shown when you press F2, i.e. this is a text format. From another excel file I have the material numbers as values e.g. 112233. I need to convert this 112233 to '112233, but in a way so the apostrophe is only shown when you press F2. I have tried several formulas e.g. =concatenate, =text etc. and can easily get the '112233 with the apostrophe shown, but not as "real" text. Does really appreciate you help in this, thanks a 1000 times Best Jakob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert a value to a text incl apostrophe within the cell
"Jakob" wrote in message
... Dear experts, I need a workaround BW reporting and the use of pivot tables in Excel. BW downloads e.g. material numbers incl an apostrophe e.g. '112233. However, this apostrophe is only shown when you press F2, i.e. this is a text format. From another excel file I have the material numbers as values e.g. 112233. I need to convert this 112233 to '112233, but in a way so the apostrophe is only shown when you press F2. I have tried several formulas e.g. =concatenate, =text etc. and can easily get the '112233 with the apostrophe shown, but not as "real" text. Does really appreciate you help in this, thanks a 1000 times Best Jakob Jakob First insert a helper column. =CHAR(39)&A1 Copy down (should see '123344) Select helper column Copy Paste special (in the same spot)/values Search/replace ' with ' replace all - worked for me. HTH for you. Beege |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert a value to a text incl apostrophe within the cell
"Beege" wrote in message ... "Jakob" wrote in message ... Dear experts, I need a workaround BW reporting and the use of pivot tables in Excel. BW downloads e.g. material numbers incl an apostrophe e.g. '112233. However, this apostrophe is only shown when you press F2, i.e. this is a text format. From another excel file I have the material numbers as values e.g. 112233. I need to convert this 112233 to '112233, but in a way so the apostrophe is only shown when you press F2. I have tried several formulas e.g. =concatenate, =text etc. and can easily get the '112233 with the apostrophe shown, but not as "real" text. Does really appreciate you help in this, thanks a 1000 times Best Jakob Jakob First insert a helper column. =CHAR(39)&A1 Copy down (should see '123344) Select helper column Copy Paste special (in the same spot)/values Search/replace ' with ' replace all - worked for me. HTH for you. Beege Or check out the code on this page... http://msdn.microsoft.com/library/de...UsingExcel.asp Beege |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
Cell has an apostrophe and is text | Excel Discussion (Misc queries) |