Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I think that cell might be formatted as Text - change the format to
General, click on F2 then <Enter. Or, it might be that your calculation mode has been set to Manual. Click on Tools | Options | Calculation tab and ensure that this is set to Automatic. An alternative way of writing your formula is this: =AB2&" "&AC2 which puts a space between the two strings. Hope this helps. Pete On Jan 23, 4:18*pm, paintsr wrote: Cell ab WSDA-LaGasa-018 cell ac *Legs removed for Barcode Project Jan09 When put in the formula by typeing no luck if I manually click on the fields it works sometimes. =CONCATENATE(AB2,AC2) is the formula....Seems like it does not want to actually calculate. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
linking text strings to other cells | Excel Discussion (Misc queries) | |||
Comparing text strings in cells | Excel Discussion (Misc queries) | |||
concatenate strings | Excel Worksheet Functions | |||
How to skip cells with text strings. | Excel Discussion (Misc queries) | |||
space between text strings with concatenate | Excel Discussion (Misc queries) |